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

[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?

[binu_acs]

@srk0609 can you also provide your expected result

[srk0609]

Hi this should be output. Please refer

[gabrielvilella]

@srk0609 I believe you are matching by the dates on the last comparison you tried to explain. Maybe this is what you are looking for.