Hello!
I am new to Alteryx, and hoping to get some insight on how to pivot based on the date field. I have created a workflow that displays the following results:
However, I am hoping to achieve the following by day format:
Any help would be greatly appreciated! Thank you.
Solved! Go to Solution.
Try transposing the data and then cross tabbing back keeping the key columns you wish to use. If you can supply some data, I can try to generate a small example for you.
Thanks,
Seth
Stay safe!!
Hi @batwood2 ,
Since it is not an easy task to produce a doubled header, I would suggest you doing like this.
See if this is ok for you.
Best,
Fernando Vizcaino
That worked perfectly! Thank you so much!
To All: I need the exact opposite of this! My data source is a report like the final product of this solution and I need to unravel it into a data-friendly table to feed Tableau & Spotfire visualizations. Of course the ideal is not to use reports, but their source data in the first place, but this is the funny business world we live in. Thanks for any ideas.