Match Rows based on two or more attributes
- 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
Hi All,
I want to create a workflow that creates a new column and mark rows that are a match as "Remove" (See below).
I tried the Unique tool and it's still showing the rows that does have a match under "U". My goal here is to eliminate rows that do match based on ProductID and User ID.
The best way I know is to create a new column and comment as "Remove" or "Keep". I have tried concatenating the two columns ([ProductID] + [UserID]) but it's saying the size is too big to run the workflow.
In order to avoid these two options, I am hoping someone could help me?
ProductID | UserID | AccountID | NewColumn |
123456 | SSS | NHIL5 | Remove |
123456 | SSS | HEML6 | Remove |
587654 | 45D | HLG0 | Keep |
154682 | LPP | 554HJ | Remove |
311436 | GHH | SED05 | Keep |
154682 | LPP | GGO | Remove |
745136 | RRH | 23DUP | Keep |
Thank You
Solved! Go to Solution.
- Labels:
- Datasets
- Developer
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @blitz45 ,
Sounds like you're on the right track for an easy solution with the Unique tool, but the tool does still include the first instance of that record in the "U" output. For cases where you'd only want truly unique records, the "Only Unique" macro was made and is part of the CReW Macro pack. Sounds like it would accomplish what you're looking for here.
Can check out the tool and download the tool kit here:
http://www.chaosreignswithin.com/2014/08/only-unique-macro.html
Added bonus, there's quite a few other tools with some cool functionality to add to your repertoire in there as well.
- 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
- 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
Brilliant! Thank you all!
