community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

How to transform raw data in Pivot table format to row base?

Highlighted
Meteoroid

I 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:
raw.jpgtarget.jpg

 

Thanks

Paul

 

 

 

 

 

 

ACE Emeritus
ACE Emeritus
I believe the Transpose tool is what you're looking for...
@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Meteoroid

Thank you.

Labels