Forum Discussion
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...
Anonymous let's first check each one individually to see which column has a data quality issue, add two columns and check each individually
if [Region] = "CoE" then 1 else 0
if [Sales.Role] = "Project Engineer Jr." then 1 else 0