Parse Columns into Rows without affecting other columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to get this:
to look like this:
I've tried several different things but can't seem to get it to work. Usually I would just use a formula tool to combine the IDs into one field with a delimiter and then use a parse tool to parse to rows. However, this is affecting the data because it's then assigning both IDs to both file names which duplicates the data and isn't accurate.
Any suggestions? I have the text input attached.
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @rimaissa,
This is the route I would take. Use two select tools, deselect the attachment 1 fields in the one and deselect the attachment 2 fields in the other. Then union the results.
Hope that helps,
Greg
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rimaissa
You can use transpose, regex (column name and id) and crosstab to get your desired output and keep it dynamic. Even you have more columns.🙂
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 Thank you, this worked perfectly and is future proofed!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂 @rimaissa
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂
