We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
Top Solution Authors