Forum Discussion

sunil_murthy's avatar
sunil_murthy
New Contributor
8 years ago

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.

Thanks,

2 Replies

  • Sowmya_Rayavara's avatar
    Sowmya_Rayavara
    New Contributor III

    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.

    • mithsrini's avatar
      mithsrini
      New Contributor II

      Hi Sowmya,

      This is helpful. Thanks for sharing.

      Thanks,
      Mithila JT