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
Super User
5 years ago

Anonymous I assume this merging step is after the clear/trim step? Are you doing this clean/trim on the Dim table as well. Has to be some special character that values are not matching.

 

Can you add a custom column to check the value by saying if [Region] = "CoE" or [Sales.Role] = "Project Engineer Jr." then 1 else 0 and we expect to get 1 for each row if there are some 0, which means some values are not matching.

 

just a suggestion to validate the data quality.

 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    parry2k 

    Thanks Parry for your reply. Yes I performed the trim and then executed the merge. I perform the validation you mentioned and you can see all the values are 1 ( Region = 'CoE' and Role = 'Project Engineer Jr'.

     

    When I am visualizing the data using the relationship then it tends to work, whereas the data goes missing when I am merging with the fact table. It's a strange behaviour.

     

    I need the normalized role to be added in the table in order to further merge with a seperate table with multiple key.