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 at least we know there is a data problem, and now fix is tricky. Click in the cell where value is correct, PQ shows values in the bottom and copy it and do a similar thing where value is not correct, do you see the length is different because of nonvisible character maybe. For the screenshot, it looks like all the values are in the Proper case, so the case doesn't seem to be the issue. At end of the day, there is some special character that is causing the issue and needs to fix it.