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

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

Concatinate Top and Child Fields.yxmd