Lookup Operations in Azure Data flow returns NULL Value

Sakthikumar Chinnasamy 0 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.
6,316 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247 2,001 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.