Text to Column String variables

[apepper]

I am having issues with parsing out a categorical text into separate columns.

Example: I have

Hire

Terminate

Terminate

Lateral Move

Hire

Promotion

Demotion

Hire

I want:

Hire   Promotion Demotion Terminate Lateral Move

Hire                                     Terminate 

Hire

[Kenda · Accepted solution]

Hi @apepper 

I would recommend sorting your field first. From there, you could use a couple Multi-Row Formula tools to just create different groups for the data so that you can then use the Cross Tab tool to transform your data to how you want it.

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

[apepper]

If I had employee data attached to each variable, how do I not lose that information.

Example

1  Male Hire

2  Male Terminate

3  Female Lateral promotion

4 Female  Hire

5 Female Terminate

etc

[ponraj]

It would be great if you could share the exact sample data and desired output.

[apepper]

I want to break out BPAction into separate columns

[Kenda]

@apepper 

In the workflow I had attached, I would say instead of creating and grouping by New Field2, just Group By your Employee ID field in the Cross Tab.

[ponraj]

Can you also share how the desired output should look like for the sample data you shared.