Forum Discussion
Combine tow calculated tables
Hi
I got two tables which I used as a "filter" to get the data required from the sources.
One table is called "Cars 1" and the other is calles "Cars 2 and I want to combine these two.
The combined table should have all the values from "Cars 1" and only the rows which are in "Cars 2" but not in "Cars 1" should be added to the new table.
The problem is I can only detect missing data (rows) by a combination of two values ("PS" and "Chassis number"). So if the exact combination of "PS" and "chassis number" isn't in "Cars 1", the row of "Cars 2" should be added to the combined table.
Thanks in advance!
2 Replies
- Idrissshatila
Super User
Hello Anonymous ,
check this article https://community.fabric.microsoft.com/t5/Community-Blog/Combine-multiple-tables-with-UNION-UNION-ALL-in-SQL-Server/ba-p/1696694
If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť
Hi Anonymous ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
