Lookup Operations in Azure Data flow returns NULL Value

Sakthikumar Chinnasamy 5 Reputation points

I am having two different data set. While performing the Lookup from one dataset to another dataset, I am receiving the NULL value even though values are present. I have checked the schema &  data case sensitivity and all look fine but still, the output produces a NULL value. Does anyone has idea why I'm getting output value as Null

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,506 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Vinodh247-1375 11,041 Reputation points


    Thanks for reaching out to Microsoft Q&A.

    Did you CAST(column_name) the sql statement properly which is used in the lookup?

    Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

  2. Kevin Stephens 0 Reputation points

    Assuming your issue is when running the debug session then I had a similar issue. To solve check the Debug Settings and ensure that the Row limit of the source is set high enough to include all lookup items. If too low the lookup dataset may not have the matching row in it.

    0 comments No comments