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