cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Relate Tables with "outer join" in the Data Model (not the query builder)

Hey,

 

I hope I am able to specify my problem accurately, because I'm not entirely sure how to describe it. Lets say I have two tables, one for our customers and one for Google Analytics Session Data from our website. I am able to match them and I have a customer for every Dataset in GA, but I do not have GA data for every single customer.

 

When I set-up the relationship and pull the data into a visualization or a table, I only get the intersect (e.g. all customers that have sessions), but I am not able to see all customers. So what I basically need is a left-outer join: I need all the customers (all the time) and I need the GA-Data added, where it is available.

 

Is it possible to configure this in the Data Model or do I have to build a separate table in the Query Builder?

 

Best Regards and many thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Relate Tables with "outer join" in the Data Model (not the query builder)

Hi @jlie,

 

>>So what I basically need is a left-outer join: I need all the customers (all the time) and I need the GA-Data added, where it is available.

For your requirement, you can take a look at NATURALLEFTOUTERJOIN Function and try to use it create a merged table with full records.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Relate Tables with "outer join" in the Data Model (not the query builder)

Hi @jlie,

 

>>So what I basically need is a left-outer join: I need all the customers (all the time) and I need the GA-Data added, where it is available.

For your requirement, you can take a look at NATURALLEFTOUTERJOIN Function and try to use it create a merged table with full records.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors