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 Text to column.xlsx

Text to Column String variables

apepper

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

Example: I have

Hire

Terminate

Lateral Move

Hire

Promotion

Demotion

Hire

I want:

Hire Promotion Demotion Terminate Lateral Move

Hire Terminate

Hire

Text to column.xlsx

Tips and Tricks

Parse

Preparation

Accepted answers

Kenda

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.

New Workflow2.yxmd

ponraj

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

Text to Column String variables.PNG

Text to Column String variables.yxmd

All comments

Kenda

Hi @apepper

New Workflow2.yxmd

ponraj

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

Text to Column String variables.PNG

Text to Column String variables.yxmd

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167