Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transpose Incoming Data

arnabd100
6 - Meteoroid

Hello Everyone,

 

I am playing around with Alteryx to assess it for a project. Can anyone help me with this use case? I have the incoming data as

Manager ID123
Manager NameABC
CityKolkata
StateWB

 

I want the output as 

Manager IDManager NameCityState
123ABCKolkataWB

This is a very simple transpose in Alteryx. Just wandering how to achieve this in Alteryx.

3 REPLIES 3
Kenda
16 - Nebula
16 - Nebula

@arnabd100  Also very simple in Alteryx!

 

Just use a Cross Tab tool and select your first field as the new headers and your second field as the values for new columns. Just select Concatenate for the method to aggregate, but it won't matter for this sample data.

Thableaus
17 - Castor
17 - Castor

Hi @arnabd100 

 

Cross-Tab tool can solve your problem.

 

ex.PNG

 

Cheers,

arnabd100
6 - Meteoroid

Thank you so much. It worked like magic.

Labels