Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

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

Pliew
6 - 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

 

 

 

 

 

 

ThizViz
11 - Bolide
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
Pliew
6 - Meteoroid

Thank you.

Labels