Forum Discussion
Table merge error
Hi coolshib ,
First thing I don't see Null values in the CONSOLIDATED table under RECOVERED column. I see BLANKS.
The reason for blank values is for the rows with this combination, you don't have data in REcovered table of yours. For eg:
Province/State = "Prince Edward Island"
Country/Region = "Canada"
Date = "30 March 2020"
There is no data for above combination in RECOVERED table.
Lets talk about how your joins are done:
1. Confirmed LEFT OUTER JOIN Deaths = OUTPUT_first
2. OUTPUT_first LEFT OUTER JOIN Recovered
This suggests there are some rows in OUTPUT_first which don'e exist in Recovered table. Therefore ends with BLANKS.
Also, I can't navigate through your Edit Query steps to view result at each step as it uses some DB credentials. It will be helpful to have this .pbix file without DB credentials.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi coolshib ,
First thing I don't see Null values in the CONSOLIDATED table under RECOVERED column. I see BLANKS.
The reason for blank values is for the rows with this combination, you don't have data in REcovered table of yours. For eg:
Province/State = "Prince Edward Island"
Country/Region = "Canada"
Date = "30 March 2020"
There is no data for above combination in RECOVERED table.
Lets talk about how your joins are done:
1. Confirmed LEFT OUTER JOIN Deaths = OUTPUT_first
2. OUTPUT_first LEFT OUTER JOIN Recovered
This suggests there are some rows in OUTPUT_first which don'e exist in Recovered table. Therefore ends with BLANKS.
Also, I can't navigate through your Edit Query steps to view result at each step as it uses some DB credentials. It will be helpful to have this .pbix file without DB credentials.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
