โ06-29-2018 04:51 AM
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.
Thanks,
โ10-31-2018 03:30 AM
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.
โ06-24-2020 11:16 AM
Hi Sowmya,
This is helpful. Thanks for sharing.
Thanks,
Mithila JT