SOLVED
Complex Data Text to Col Parse
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
adarshxr
7 - Meteor
‎02-26-2024
05:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Need some help in parsing the atatched data in right format. Tried Text to Coloumns but failed.
Solved! Go to Solution.
Labels:
- Labels:
- Parse
8 REPLIES 8
18 - Pollux
‎02-26-2024
05:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It looks like JSON so you should use the JSON Parse Tool (alteryx.com)
aatalai
14 - Magnetar
‎02-26-2024
05:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What settings did you use? could you import it as a data input as a csv?
Raj
16 - Nebula
‎02-26-2024
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-26-2024
06:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Alex, Can you attach the canvas, need to cross check my settings
18 - Pollux
‎02-26-2024
06:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-26-2024
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot Alex,
I need to write the output data in the below format as below, I tried using Dynamic Rename and Cross tab but didn't work,,
18 - Pollux
‎02-26-2024
07:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am not sure what the issue is, the CrossTab is exactly what I'd use here. You can then reorder / rename fields with a Select tool afterwards.
‎02-26-2024
09:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Alex
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)