Trying to Cross tab job descriptions

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!

Job Descriptions.yxmd

Accepted answers

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

Job Descriptions Solution.yxmd

All comments

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.

Cross tab Concat.yxmd

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

Job Descriptions Solution.yxmd

Hi @Maskell_Rascal,

Good old Multi-row formula 😀

I didn't think about it!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703