Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Merge Query Issue : Data for few rows not loaded for same key value

Hi All,   As you can see in the below screenshot. I am trying to fetch some normalized Sales Role from a dimension table for the Left 2 column combination (Sales Role + Region). I am using left out...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous I think I gave you the wrong condition check, if should be AND not OR, with OR if one is true we will get 1, we want to make sure both are TRUE

 

 if [Region] = "CoE" and [Sales.Role] = "Project Engineer Jr." then 1 else 0