We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Combining data with multiple entities(columns)

calvinwong
7 - Meteor

Hi!

 

If I have multiples columns representing different entities, how can i combine them into 1 column while keeping the respective data from other columns?

 

$6DCD31F53A39CB14.jpg

 

So the final output will have Account #, Account Name, Book, Tax, Entity number.

 

Thank you for your help.

2 REPLIES 2
Federica_FF
11 - Bolide

Hi @calvinwong,

 

you can easily get the result using the transpose and crosstab tools.

 

Immagine.png

 

In attachment a small example workflow

calvinwong
7 - Meteor

Hi @Federica_FF,

 

Oh wow. That was easy. Thank you so much for your help. I knew there has to be a way but I didn't think of using cross after transpose. That was very helpful. :)

Labels