SOLVED
Help with using the Cross-Tab Tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
thd-data-analyst
7 - Meteor
‎06-05-2020
07:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Best Practices
- Transformation
2 REPLIES 2
MichaelLaRose
10 - Fireball
‎06-05-2020
07:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎06-05-2020
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MichaelLaRose,
Thank you very much. This is very helpful.
Appreciate it.