Alteryx Designer Desktop Discussions

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

Missing Date Fix

DelData
8 - Asteroid

Hi There....

 

Can anyone help with this request...I have region data and everyone if a sale takes place then 1 shows in the month...as shown below

 

Dates Before.png

 

but what i need is.....for each region go to the first month where 1 shows and fill in missing 1's for each subsequent month and include the current month to give this.....i really just need all the yellow blank months filled in with 1 as shown below.....

 

Dates After.png

 

.....as you can see the current month Jan-24 is empty in the before pic, and if current month is empty then i need it to be included and marked as 1...

 

Sample Data Excel attached....any help would be great :)

 

2 REPLIES 2
gawa
16 - Nebula
16 - Nebula

hi @DelData 

Please try the attached WF.

image.png

 

Trick herein is "cross-tab and transpose in a row. By doing so, you can have the data like below so you ca easily replace Null with 1 by Multi-row formula at downstream. 

image.png

DelData
8 - Asteroid

Thank you....this works and really has helped me fix a question i had some problems with....thank you ðŸ˜€

Labels
Top Solution Authors