Deleting certain records
- 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 have a list of customers and partners that I have to sort through. If the customer and the partner are the same number I can delete it. If the customer and partner are different numbers I have to keep the entire record.
In the above example 10042 and 10054 can be deleted but all records for 10044 and 10068 must be kept.
I'm drawing a blank on how to do this so any help is much appreciated.
Thanks!!
Solved! Go to Solution.
- Labels:
- Datasets
- Text Mining
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @JohnO ,
You can use the filter tool to achieve that.
I would suggest you going through the alteryx for excel users lessons, that would help you figure these things out. :)
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
probably just an issue with generating sample data but in your example you say 10042 and 10054 can be deleted but all records for 10044 and 10068 must be kept. but you have some of 10044 and 10068 records where partner and customer match. so did you intend to delete those? or did you intend to retain all records for a customer where at least one had a mismatching partner value? the latter is a more complex solution, I did not look closely but @DataNath 's solution seems right for that scenario....the simpler filter suggestion by @fmvizcaino might be the way to go. interested to have you clarify.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have to admit I was confused by the wording as it initially seemed like a simple filter would do the trick, but then the fact that 10044/10068 should be kept suggested that if there was ANY records between a customer/partner that didn't match then you had to keep all records for that ID. Obviously if it's the former then the single filter tool will do the trick!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks DataNath! That wasn't the exact solution but it did put me on the path to solving (I think) my issue. I greatly appreciate it!
