Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Transpose help

Chelseaa
7 - Meteor

Hi all, 

 

I need some help regarding this:

 

Input file: 

RegionMonthProduct CostTransportSavings
AMERJan 34-1
AMERFeb23-2
AMERMar220
APACJan 65-1
APACFeb72-0.5
APACMar530

 

Desired Output file:

RegionMonthCost TypeValue for Col 1Value for Col 2
AMERJanProduct Cost3 
AMERJanTransport4 
AMERJanSavings -1
AMERFebProduct Cost2 
AMERFebTransport3 
AMERFebSavings -2
AMERMarProduct Cost2 
AMERMarTransport2 
AMERMarSavings 0
APACJanProduct Cost6 
APACJanTransport5 
APACJanSavings -1
APACFebProduct Cost7 
APACFebTransport2 
APACFebSavings -0.5
APACMarProduct Cost5 
APACMarTransport3 
APACMarSavings 0

 

I have tried to transpose twice, but i have no idea how to merge "savings" under the "Cost type" column.

 

Thank you in advance!

2 REPLIES 2
Raj_Singh1
9 - Comet

Hi @Chelseaa 

 

Please see attached. Can you please accept it as solution if its work for you . if any issues let me know and i can make changes to workflow .

 

Thanks 🙂Capture 6.JPG

AbhilashR
15 - Aurora
15 - Aurora

Hi @Chelseaa@Raj_Singh1 has already presented an approach but I wanted to propose an alternate way of reaching the same goal. 

AbhilashR_0-1606362880437.png

I hope this helps.

Labels