How to give conditions using a look up file in ADF

Question

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 .

Answer 1

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

Answer 2

Thank you so much, tried that and worked

Answer 3

Can you provide some more details into how you made this work?