Forum Discussion

Precy's avatar
Precy
New Contributor
5 years ago

Need to do lookup on multiple tables without using join

I have 30 tables to lookup on 30 respective columns, In case of other ETL tool we had lookup as a function to do it independently in a single transform. In snaplogic, I am not sure how to do it. ...
pipeline
Precy's avatar
Precy
New Contributor
5 years ago
Copy Link

@ Supratim,

I am little confused with above explanation. Is it possible for you to showcase this with an example please

  • Precy's avatar
    Precy
    New Contributor
    5 years ago
    Copy Link

    I will give you an example how i want the result as,

    1. From my input i have 2 fields assettype and ITEMSETID on which i need to do cross reference.

    2. I will have the 2nlookup tables merged as below:

    1. How can i achieve target_column for corresponding attributes when i do lookup on source column without using 2 joins.