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.
Solved! Go to Solution.
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.
Cheers,
Mark
Mark! such a lifesaver!!! Thank you
a lot of time was saved with this solution.
Regards,
Israel