Trying to Cross tab job descriptions

[krishnagandhi]

HI have data where there are can be anywhere from 1 to probably 7 different job titles per employee record. What i am trying to do is get the data to crosstab, but having issues

What i need is for each id i want multiple columns that list all the possible job titles. I don't have any way to cross tab this data. Can someone suggest a solution?

Thanks!

[Emil_Kos]

Hi @krishnagandhi,

This was fun 😛

I have cleaned the data and concatenated them together. After that I have used text to columns to split the data.

I wonder what are the other options to complete it. 

[Maskell_Rascal · Accepted solution]

Hi @krishnagandhi 

This can be accomplished by adding in a RecordID with the Multi-Row formula tool and grouping by ID. 

See attached workflow. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[Emil_Kos]

Hi @Maskell_Rascal,

Good old Multi-row formula 😀

I didn't think about it!

[Maskell_Rascal]

@Emil_Kos - one of my favorite things about Alteryx is how many different approaches there can be to a problem. 🤓