community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Filling blank column fields with precedent amount

Highlighted
Meteoroid

Hello Alteryx Community, I have this cohort analysis, which I need to be in this pivot way.

 

In the attached image, it shows how null spaces are affecting my analysis. What I expect is that for example:

Those blank spaces after the 5 would be populated with 5 and the ones after the 4 would be populated with 4 and so on.

 

Please help on this. I am attaching a picture of the workflow as well as the data is highly sensitive to share the wflow.Alteryx cohort - non populated fields.PNG

Capture for alteryx.PNG

Alteryx Certified Partner
Alteryx Certified Partner

@isilvera ,

 

Glad to help this fine Friday.  Using a TRANSPOSE I can inspect the data in order.  I make the NULL updates and revert back to the original horizontal format using the CROSS TAB.

 

There are a few configurations to watch for.  Please open my workflow and see what is happening.

 

capture.jpg

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteoroid

Mark! such a lifesaver!!! Thank you

 

a lot of time was saved with this solution.

 

Regards,

Israel

Labels