Filter Data Based on Large Combination of Columns from Excel Sheet

[hovicke]

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

Employee ID

Employee Name

Manager Name

Application 1

Entitlement 1

Application 2

Entitlement 2

Type

Risk

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

Application 1

Entitlement 1

Application 2

Entitlement 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!

[ChrisTX]

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

[NMangera]

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