This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Learn MoreI have a raw data that comes in a pivot table format (example the raw data below with just data1 and data2) . Wanted to revert the pivot table (refer target format)
1) all date in date
2) all data in column name starts with "data" are to be ingested to a single value" column.
3) all column's name are to be ingested in the "data" column respectively.
Tried using the "Arrange" tool but finds it not productive when I have a large number of column to convert, any idea how to do this more effectively?
The raw data: | Target format: |
Thanks
Paul
Solved! Go to Solution.
Thank you.