Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I was wondering if there is a way of merging two tables that would provide this result set.
Table A:
ID | Activity | Creation Time |
1 | 1 | 11:00 |
2 | 0 | 12:00 |
3 | 0 | 13:00 |
4 | 0 | 10:30 |
5 | 0 | 11:00 |
6 | 0 | 12:00 |
Table B:
ID | Activity | Creation Time |
2 | 3 | 12:00 |
7 | 2 | 9:00 |
8 | 2 | 10:00 |
9 | 2 | 10:30 |
10 | 2 | 10:00 |
11 | 2 | 8:00 |
I want to get back everything from Table B, plus everything in Table A EXCLUDING anything that has the same ID as something in Table B, so this is the data I want returned:
ID | Activity | Creation Time |
1 | 1 | 11:00 |
2 | 3 | 12:00 |
3 | 0 | 13:00 |
4 | 0 | 10:30 |
5 | 0 | 11:00 |
6 | 0 | 12:00 |
7 | 2 | 9:00 |
8 | 2 | 10:00 |
9 | 2 | 10:30 |
10 | 2 | 10:00 |
11 | 2 | 8:00 |
Any suggestions? I've tried the Merge in Power Query and that doesn't allow a bespoke option. I was wondering if I need to do this as part of a union of the two tables? But cannot work out how to write this.
Solved! Go to Solution.
Thank you @Mariusz, your answer helped me work out the correct answer. You need to do this to create a new table, then use a union to join the extra data you are missing in. Thanks
Hi @Anonymous
You need to merge Join Kind - Left Anti()
Remove the new column created from Table A
Next Append Both tables
Please see the attached file for ref.
Thank you @Mariusz, your answer helped me work out the correct answer. You need to do this to create a new table, then use a union to join the extra data you are missing in. Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.