Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Converting Columnnar data into rows

Purpose
7 - Meteor

Hi
I have a four column data set as follows:

 

Account USCO US OUS
100          1       4       7
150          2       5       8
200         3        6       9

 

I will need to convert it into below two columns data set 

Account          Amount
100-USCO       1
150-USCO     2
200-USCO      3
100-US           4
150-US           5
200-US          6
100-OUS       7
150-OUS       8
200-OUS       9

 

I have used three different connectors and used formula tool to come up with new Amount column and values for the account column. Then I used the union tool to combine the three outputs into a single output. The 3 column headers (USCO, US and OUS) are constant.

 

I am wondering if there is a better way to accomplish this in Alteryx. Any ideas are greatly appreciated.

 

Purpose G.

2 REPLIES 2
ponraj
13 - Pulsar

Here is my sample workflow. 

 

Converting Columnnar data into rows.PNG

Purpose
7 - Meteor

Ponraj,

Great!.  I like your solution. It is simple and efficient.  Thanks a lot.  They is resolved now. 

 

 

Purpose

Labels
Top Solution Authors