Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Eli181
Contributor II
Contributor II

Multiple Concatenate and then Multiple Join Tables

Hi. 

Here is the following problem:

I have 7 tables: A, B, C, D, E, F, and M.

  1.  I have to concatenate the first 3 (A, B, C) as ABC Table  ... with a Product ID
  2. I have to concatenate the next 3 (D, E, F) as DEF Table ... that carries the same Product ID but other fields
  3. I have to outer join ABC Table to M as MABC ... along same Product ID but more fields
  4. I have to outer join DEF Table to MABC as MABCDEF ... alond same product ID

or the other option is to

  1. Outer Join ABC and DEF for a ABCDEF table, and 
  2. Outer Join M to ABCDEF.

What would be the script to address this issue?

I was able to run 1, and then 3 ... but then the join with DEF duplicates rows rather than "merge" rows (as it would be said in PowerBi)

Thank you for your help.

JM

Labels (2)
1 Reply
jerifortune
Creator III
Creator III

In Step 1 and 2, do you mean Left JOIN or Concatenate (Union)?