Discrepency in Join and Lookup in Azure Data Factory

Monica Manoharan 66 Reputation points

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.


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,093 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MarkKromer-MSFT 5,206 Reputation points Microsoft Employee

    Lookup is a left outer join in ADF

    1 person found this answer helpful.