Discrepency in Join and Lookup in Azure Data Factory

Question

question

MonicaManoharan-9413 asked May 4, '22 AnnuKumari-MSFT commented May 9, '22

Discrepency in Join and Lookup in Azure Data Factory

Hello Team,

I have a look up which has two filter conditions and then a derived column that has the condition isMatch() for all the output rows. Based on the derived column value, there is a conditional split. The Derived column is actually returning the value "False", whereas the expected value is "True".

So, I tried replacing the Lookup activity with Inner join and that is actually returning the correct row matching with the input. Can you please let me know why there is a discrepancy in these two activities or the Lookup activity is not working.

Thanks,
Monica.M

azure-data-factory

· 1

5 |1600 characters needed characters left characters exceeded

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

RyanAbbey-0701 · May 05 at 08:42 PM

Can do with some expansion on what issue you're facing, maybe a screenshot or two

The lookup activity definitely works as expected

0 ·

Answer 1 · 2022-05-04T22:44:48.66Z

MarkKromer-MSFT answered May 4, '22 AnnuKumari-MSFT commented May 9, '22

Lookup is a left outer join in ADF

· 1

5 |1600 characters needed characters left characters exceeded

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

AnnuKumari-MSFT · May 09 at 09:51 AM

Hi @MonicaManoharan-9413 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help

0 ·

question