Filter based on an input file

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

Accepted answers

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:

2020-04-15 data prep sample.yxmd

All comments

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:

2020-04-15 data prep sample.yxmd

Oh that is brilliant thanks so much

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!

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.

Find Replace Fruit.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335