Table merge error

[coolshib]

Dear All,

I have three table as confirmed, recovered & death.

When i try to merge all table together i get null value under recovered column of the merged table data.

Attached here with the pbix file for your reference.

<iframe src="https://onedrive.live.com/embed?cid=B52CAD1EB6C3FE36&resid=B52CAD1EB6C3FE36%21166&authkey=AIoettQaUa..." width="98" height="120" frameborder="0" scrolling="no"></iframe>

Thanks in advance.

Best Regards,

Shib

[Pragati11 · Accepted solution]

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

[coolshib]

@Pragati11 

Thank you so much for your help.

Best Regards,