Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fill Dates

cterrence
8 - Asteroid

Hi 

I can do this in excel but im struggling in Alteryx

 

I have this data set like this 

 

cterrence_0-1687149606875.png

Essentially I want dates columns to be filled according to the corresponding date entered above.
I want the data to be like this 

 

cterrence_1-1687149701453.png

I have one big workbook in which the dates are not filled. 

Please assist

 

Regards

CT

3 REPLIES 3
Raj
16 - Nebula

Go through multirow formula tool
in the example tab similar situation is been solved

IF IsNull([Date])
THEN [Row-1:Date]
ELSE [Date]
ENDIF

BRRLL99
11 - Bolide

Use Multirow formula 

and update in existing field

 

BRRLL99_0-1687152168558.png

 

cterrence
8 - Asteroid

Thanks you @BRRLL99  and @Raj . It worked. 

Labels