How to fetch matching records where columns matches in two separate excels?

actually i have two excels where one is static and other is dynac where need to fetch values matching on 3 values from static .
select * from static where colum1=(select columns 1 from dynamic) and colum2=(select columns 2 from dynamic) and column3 = (select columns 3 from dynamic).

used inmemory lookup doesn’t working as my expectation.


Hi Sunil,

Read two files and use join snap to get the desired output.
This is the similar use case as yours.I have used left outer join as per my requirement. You can use any other join.
Check this sample pipeline to get more clarity.