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?
Solved! Go to Solution.
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
Hi @MichaelLaRose,
Thank you very much. This is very helpful.
Appreciate it.