Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Filter based on an input file

Highlighted
6 - Meteoroid

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

 

Highlighted
Alteryx Certified Partner

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:

1.PNG 

Highlighted
6 - Meteoroid

Oh that is brilliant thanks so much

Labels