Match Rows based on two or more attributes

[blitz45]

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

[NickSm · Accepted solution]

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.

[JosephSerpis · Accepted solution]

Hi @blitz45 I mocked up this workflow that produces the result you describe. 

[PhilipMannering · Accepted solution]

This should also do the job,

[PhilipMannering · Accepted solution]

This is probably a quicker way to do it,

[blitz45]

Brilliant! Thank you all!