Can someone point me in the right direction to get the desired output from the sample file attached.
Solved! Go to Solution.
Hi @sghimire ,
To get the data in that exact format you will want to combine data based on type and date, and then provide unique identifiers for the different dates. Once, this is done you will need to perform two cross-tabs and you will get the final table by joining the two cross-tab results together.
Please see the attached workflow.
I hope this helps!
Hi @sghimire ,
Not sure if it is the best solution, but it does the job!
I'm attaching an example showing how to get that done. The only detail is, since Alteryx can't handle columns with the same name, I've inserted a number after each column to order them properly.
Best,
Fernando Vizcaino
Perfect. Thanks for the help.