Forum Discussion

Niels_NL's avatar
Niels_NL
Icon for Advocate I rankAdvocate I
10 years ago

Merge two tables into one

Hey guys,   so I've got two tables now: Customers CustomerID CustomerName Locationdata Businessdata Marketingpreferences CustomerID CustomerName Marketingpreference1 Marketingpreferenc...
Need Help
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago
Niels_NL for the rest 3000 it will give null rows right ? In NewColumn click on Table and you will be able to choose which columns to be merged.
Niels_NL's avatar
Niels_NL
Icon for Advocate I rankAdvocate I
10 years ago

ankitpatira No, the 3000 other customers without marketing-data just isn't inserted.

I'm still having a total amount of 3000 records in the table, instead of 6000 where 3000 would have 'null'-values.

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Niels_NL

     

    Merge query with "Left Outer" join does work, do note the join order. I doubt it is Market Left Outer Join Custmer in your case.


    I've attached the test pbix for your reference. If you have any question, feel free to let me know.