Help with using the Cross-Tab Tool

[thd-data-analyst]

Hello,

I wanted to ask for some help regarding the Cross-Tab tool. My data is like this:

ID	Cat_path	Top	Child
100234	Level1->Level2>Level3	Level1	Level3
100234	LevelA->LevelB->LevelC	LevelA	LevelC

I want to get to a state like this:

ID	Top Levels	Child Levels
100234	Level1,LevelA	Level3,LevelC

Can someone please guide me how I can achieve this?

[MichaelLaRose · Accepted solution]

Hi @thd-data-analyst,

Cross tab isn't the easiest tool to accomplish what you are looking for.

Instead, you can use the summarize tool and concatenate the data to accomplish this goal.

See the attached workflow.

Best,

Michael

[thd-data-analyst]

Hi @MichaelLaRose,

Thank you very much. This is very helpful.

Appreciate it.