Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

select columns to columns

Holidayday
6 - Meteoroid

Hello I have a table like this:

 

 

Company Name|Account Name|2018 Amount|2019 Amount

 

ACB|Revenue| $$$$|$$$$$

EFC|Revenue

EFG| Costs 

ABC|Costs

EEE|Revenue

EEE|Costs|

EEE| EBITA

 

 

 

and I want the data table to be like this"

 

Account name| ABC|EEE|EFG

Revenue         | $$$$|$$$$|$$$$

Cost

EBITA

 

 

Can you please help to on how to get this done? Thank you!

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Holidayday 

 

Here is how you can do it.

 

workflow:

atcodedog05_0-1622785005323.png

 

1. Using transpose tool converting columns to rows with key as company name & account name

2. Using crosstab tool with key as account name & name (years) converting back to table with company name as name and value as value. This gives a year level breakdown

atcodedog05_1-1622785125738.png

or

2. Using crosstab tool with key as account name converting back to table with company name as name and value as value. This gives a sum of years.

atcodedog05_2-1622785232290.png

 

Hope this helps 🙂

 

bharatandalam
8 - Asteroid

Hi @Holidayday 

 

Please have look at the attached workflow

 

bharatandalam_0-1622787012449.png

 

Labels
Top Solution Authors