Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

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

Highlighted
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

 

 

 

 

 

 

Highlighted
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
Highlighted
6 - Meteoroid

Thank you.

Labels