SOLVED
Select ALL records tied to an ID if any one record contains a value
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
vertika
6 - Meteoroid
‎11-07-2019
03:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I have the dataset as under. I want to select ALL records tied to a Record ID if any of the rows have 'SEA' in either Origin or Destination.
For example, Record ID has 3 rows. Only two rows tied to Record ID 1 have SEA in either Origin or Destination, but I want to select ALL three rows. Record ID 2 has no rows that contain SEA in any of its two columns, so I want to filter that out. Record ID 3 has only one row that contains SEA as destination, but I want to select all 3 rows connected to record ID 3.
Any suggestions? Thanks!
Record ID | Origin | Destination |
1 | SEA | XNA |
1 | MSP | CLL |
1 | CLL | SEA |
2 | LAX | CLL |
2 | HOU | LAX |
3 | JFK | AUS |
3 | LAX | AUS |
3 | MSP | SEA |
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
Alteryx
‎11-07-2019
03:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-07-2019
03:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
THANK YOU!
This worked perfectly!
