Hi team,
I have data in the Alteryx in the below format of the headers.
Category | Unit | Plant1 | Apr-23 | May-23 | Jun-23 | Plant2 | Apr-23 | May-23 | Jun-23 |
and so on till Plant14
I want the union the data based on Plant 1 , Plant 2 and So on.
Below is the result format.
Category | Unit | Plant1 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | FY 24 |
A | X | ABC | Any value | ||||||
B | Y | ABC | |||||||
C | Z | ABC | |||||||
Category | Unit | Plant2 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | FY 24 |
And so on till Plant 14.
I have approximate 14 Plants so i want the union of each plant below each other.. Please let me know if you have any questions.
Best Regards,
Kaustubh
Yep, same workflow except I added a sort at the end.