ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.
SOLVED

Need help transposing data into columns from one column by finding duplicates

CHolston32
5 - Atom

Hi -

 

As an example:
I have 10k rows of employees (email address as unique identifier in column A) that are placed into certain groups, in column B. Some of these employees are duplicates because they belong to more than one group. 

 

I need a workflow that will read Column A and search for duplicates and transpose the info in column B when it finds a duplicate. 

 

Output:
Every row is unique, Column A is email addresses, and Columns B...C....D....E so forth are the multiple groups any one employee may have.

 

Thank you! Urgency is appareciated!

JulioMO
9 - Comet

Hi @CHolston32,

 

The key Tool here is the Cross Tab Tool. 

 

I attach a workflow that performs what you want. 

 

Hope it helps!

 

Regards

CHolston32
5 - Atom

Thank you! Trying this now, truly apreciate the workflow!!

CHolston32
5 - Atom

Again thank you Julio! Looking at the Cross Tab tool, I think the workflow is "matching" the columns. But realistically, there are 45 groups and 3k+ employees so I cant have the groups across the columns and it "match" 😞 but instead, I DO KNOW that no single employee is mapped to more than 4 groups. So I am hoping to have the output with just 4 additional columns showing each group, transposed. I have attached an example, apologies I did not attach it before. 

Any help is truly appreciated! Trying to get ahead of a client and work some Alteryx magic 🙂 THANK YOU!

JulioMO
9 - Comet

Hi @CHolston32 

 

No problem! Here goes the new workflow. Let me know if it works for you. 

 

Regards

CHolston32
5 - Atom

This is beautiful, I cannot thank you enough!! Worked perfectly. Thank you!!!!