Hi
I can do this in excel but im struggling in Alteryx
I have this data set like this
Essentially I want dates columns to be filled according to the corresponding date entered above.
I want the data to be like this
I have one big workbook in which the dates are not filled.
Please assist
Regards
CT
Solved! Go to Solution.
Go through multirow formula tool
in the example tab similar situation is been solved
IF IsNull([Date])
THEN [Row-1:Date]
ELSE [Date]
ENDIF
Use Multirow formula
and update in existing field