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

Alteryx designer Discussions

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

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

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