Log In
Register
Home
May 27, 2014
Offline
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
Trusted Members
Moderators
November 1, 2018
Offline
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.
May 27, 2014
Offline
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
1 Guest(s)
