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...
Sowmya_Rayavara's avatar
Sowmya_Rayavara
New Contributor III
7 years ago

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
    6 years ago

    Hi Sowmya,

    This is helpful. Thanks for sharing.

    Thanks,
    Mithila JT