Lookup Operations in Azure Data flow returns NULL Value

Sakthikumar Chinnasamy 5 Reputation points
2023-01-15T01:22:27.3966667+00:00

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
    2023-01-15T09:23:33.8133333+00:00

    Hi

    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
    2024-02-08T16:33:25.8+00:00

    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