SOLVED
Removing data
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
vivian123
7 - Meteor
‎06-18-2021
10:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
What is the best way to remove rows based on a values in another column in this situation?
If there is more than one purchased item per customer then I want all data for that customer removed.
Input table
Customer ID | Purchased item ID |
123 | 666 |
123 | 999 |
234 | 111 |
456 | 888 |
789 | 555 |
Output table
Customer ID | Purchased item ID |
234 | 111 |
456 | 888 |
789 | 555 |
Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Topic of Interest
2 REPLIES 2
Qiu
21 - Polaris
‎06-18-2021
10:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-19-2021
08:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!!