Filter based on an input file

[RR8]

Hi

Please can someone help me 

I have simplified my question, but I am working with a very large dataset.

I have a data set (A) for example with two columns of data for example Apples 5, Oranges 20, Pears 25, Lemons 18, Grapefruit 26....

I have another file (B) that has Oranges, Pears

I want to filter Dataset A

with Dataset B

so that Dataset C returns Oranges 20, and Pears 25

Please can you help me - I have been trying to find this 

Thanks
RR8

[Aaron_Harter · Accepted solution]

Hi @RR8, 

Try using a Join to filter the data, the J output will contain only records from File A that have a match in File B:

 

[RR8]

Oh that is brilliant thanks so much

[r_gratz]

Hello @Aaron_Harter ,

is there a way to do the same, but with the difference that I would need to filter on condition "contains" rather than "is equal"?

Thank you!

[Matt_D]

Hi @r_gratz you could use the Find Replace Tool for this. A couple of configurations to take note of are how you find the field, e.g. Beginning of Field or Any Part of Field and the case sensitivity. My workflow is case sensitive as I have not ticked the option Case Insensitive Find.