Either combine Name|Marks and Name|Class and then do two joins using the merged column for the lookup or split Condition Value in two and do two lookups using two columns to join... either way, you're doing two lookups - one filtered to "Name|Class" and the other filtered to "Name|Marks", put those as part of your query on the lookup
How to give conditions using a look up file in ADF
Johny, Sijo
21
Reputation points
I have 2 csv files like below , I want to derive a new column based on the Condition, Condition Value and Variable from a lookup file .
Accepted answer
2 additional answers
Sort by: Most helpful
-
Johny, Sijo 21 Reputation points
2021-07-25T17:56:16.25+00:00 Thank you so much, tried that and worked
-
Mike Martin 1 Reputation point
2021-10-29T15:31:31.497+00:00 Can you provide some more details into how you made this work?