Filter Data Based on Large Combination of Columns from Excel Sheet

Question

Hi - I have a data set that I've filtered down the point where I have the following columns:

Employee IDEmployee NameManager NameApplication 1Entitlement 1Application 2Entitlement 2TypeRisk

I have another excel spreadsheet where I only have the following columns:

Application 1Entitlement 1Application 2Entitlement 2

This second spreadsheet has about 100 combinations of those 4 columns that we are considering "bad" and we need to know about. The first spreadsheet has some "bad" combinations and some "good" ones (we don't care about the good ones). How would I go about filtering the first spreadsheet to only show me the "bad" combinations (I still want to keep all columns here including employee and manager info, type, risk)? I know I could put in a very wordy filter that lists out every single "bad" combination, but that spreadsheet will be constantly updated, so I didn't know if there was an easier way going about this.

I hope this makes sense and I can clarify if need be!

Thank you in advance!

NMangera · Answer

Hi @hovicke,

by bad 'combinations' I assume you are referring to rows/records of data. You could join the two tables together with common linking fields set against Application 1, Application 2, Entitlement 1 and Entitlement 1 (or some combination ), and then use the output of the Left/Right output anchor to filter for the data of interest. This solution would prove resilient to changes/updates to the data

ChrisTX · Answer

Could you just use a Join tool?  The records in the J output anchor would be your "bad" records.

Guessing I'm over simplifying.  Can you provide some mocked up sample input and expected output?

Chris