question

JohnySijo-2036 avatar image
0 Votes"
JohnySijo-2036 asked MikeMartin-8123 published

How to give conditions using a look up file in ADF

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 .

115097-image.png


115050-image.png


azure-data-factory
image.png (4.8 KiB)
image.png (3.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RyanAbbey-0701 avatar image
0 Votes"
RyanAbbey-0701 answered SaurabhSharma-msft commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@johnysijo-2036 Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

0 Votes 0 ·
JohnySijo-2036 avatar image
0 Votes"
JohnySijo-2036 answered

Thank you so much, tried that and worked

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MikeMartin-8123 avatar image
0 Votes"
MikeMartin-8123 answered MikeMartin-8123 published

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.