Forum

Column with differe...
 
Notifications
Clear all

Column with different type of values

4 Posts
3 Users
0 Reactions
98 Views
(@canetas)
Posts: 15
Eminent Member
Topic starter
 

Hello everybody,

 

I have one column with a "date" in one row and different "SKU's" beneath and again a "date" followed by other "SKU's"...

I need to pull the "dates" to another column next to the corresponding SKU's

 

Index with Modulo doesn't work because the rows that separate the dates vary.

 

Thanks in advance,

Stay safe

Miguel

 
Posted : 06/03/2021 9:08 am
(@debaser)
Posts: 837
Member Moderator
 

You could add a column using a formula like:

Value.Is([field name], type datetime)

 

 to return True for the dates and False otherwise. You can then use another column to return the date if true, null otherwise, then Fill the new column down. You can then filter on the first column to remove the True rows.

 
Posted : 06/03/2021 11:35 am
(@canetas)
Posts: 15
Eminent Member
Topic starter
 

Thanks Velouria for your help it was very useful, here's what hapened:

 

a) With the formula Value.Is([field name], type datetime) it returned False for all the rows including the rows with dates.

 

b) Then I tried the formula  Value.ReplaceType([field name], type date)  and worked as long as I have the column "Field name" as Data Type > Any

   The values other than dates gave Error, than I substitute for "null" and Fill down.

 

Miguel

 
Posted : 08/03/2021 8:18 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

Hi Miguel,

So your problem is resolved?

regards

Phil

 
Posted : 15/03/2021 11:18 pm
Share: