SOLVED
How to parse a column
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
clarrock
8 - Asteroid
‎11-01-2023
11:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
eHi,
Below is my input data
Vehicle | Notes | Flag |
CAR | abc1234 abc345 | Yes |
BUS | abc78908 2344 capture abc785 | No |
I want to parse my notes column such that anything with the term "abc+number" (ideally ignore anyother number and text like "capture" and "2344" creates a new record with the same vehicle and flag and only the number
This is my desired output
Vehicle | Notes | Flag |
CAR | 1234 | Yes |
CAR | 345 | Yes |
BUS | 78908 | No |
BUS | 785 | No |
Is this possible on Alteryx?
Solved! Go to Solution.
2 REPLIES 2
17 - Castor
‎11-01-2023
11:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
flying008
15 - Aurora
‎11-02-2023
12:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
