AnsweredAssumed Answered

Board 11: There is a problem in the data reader. When executed, the Data Reader is failing to recognize the values returned by an IF function.

Question asked by sugunendra on Jan 10, 2020

When using an IF condition to return Entity code, for "Vendor LFL" entity below, which is to be referred while reading into a data cube, "LFL Vendor"

 

even though the ETL window is showing the expected output, which is the entity code of a member in "LFL Vendor" entity

 

 

the Data reader is not recognizing the returned entity code and attributing all the records to empty member of the same entity.

 

 

Seems logically correct to me and I implemented something similar one in Board 10.3 but the same is not working here in Board 11. Please help me with the right way to execute something like this in Board 11. Thank you.

Outcomes