cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Left join issue

Hello,

 

I have some issues in joining two tables. I have the TENANT table which has all tenants information and UNITS table which has all buildings units information. I need to join these two tables in order to create some analysis. The problem is that I have some vacant units with no tenants, thus they do not exist in TENANT table but they exist in UNITS table. Therefore, I create a left join so I keep the vacant units in my joined table.

 

The totals of the table are correct but the vacant units do not appear in the joinned table.

 

Can you please give some ideas why this is happening?

 

Many thanks,

Marios 

3 REPLIES 3
gooranga1 Senior Member
Senior Member

Re: Left join issue

hi @Anonymous

 

I presume you are using the "Merge Queries" drop down on manage queries?

 

If you are did you execute the merge with UNITS as the top query and TENANT as the bottom query in the Merge dialogue when you specified Left Outer (all from first,matching from second)?

Anonymous
Not applicable

Re: Left join issue

Hello gooranga,

 

Many thanks for your prompt response. Yes first was the UNITS and second was the TENANTS as I need to keep all the information from units table.

 

Best regards,

Marios

gooranga1 Senior Member
Senior Member

Re: Left join issue

I just did a quick test and I can merge the tables keeping all the units? is that hpw you merged your tables?

merged1.PNGMerged.PNGTenant.PNGUnits.PNG

 

 

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors