Filter a file based on unique values of another file in same workflow

srk0609

I want to find unique values in Fruits column, Price column of File 1 and use those values to filter file 2 data. I want it to be dynamic since new values can get added.
I want to compare   Quantity type field from File 1 to unit_1, unit_2 field in File 2 and Form 2 new columns in file2 "quantity type" which has same quantity type as file 1 and "quantity" which has same quantity as quantity in file 1.

PFA file below. It would be great if someone could help

sample.yxmd

terry10

I don't understand the comparison you wish to make, but I can start by helping you filter File 2 by unique Fruit & Price. (see attached workflow)

1. use a summary tool - group by to dynamically create a unique list of whatever fields you want 

2. use a join tool to filter File 2 based on that unique list. File 1 filtered flow out the J anchor.

Does this help you get started?

Can you restate the comparison you wish to make more clearly?

sample1.yxmd