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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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.
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.