Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter based on an input file

RR8
7 - Meteor

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

 

4 REPLIES 4
Aaron_Harter
11 - Bolide

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 

RR8
7 - Meteor

Oh that is brilliant thanks so much

r_gratz
6 - Meteoroid

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
9 - Comet

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.

 

 

 

Labels