Notifications
Clear all
Topic starter
Hi,
i have Table1:
Field1;Field2;Diff1;Diff2 [Headers]
| 1 | 1 | Dif11 | Dif11 |
| 1 | 2 | Dif22 | Dif22 |
and Table2:
Field1;Field2;Diff1;Diff2 [Headers]
| 1 | 1 | Dif11 | Dif11 |
| 1 | 3 | Dif22 | Dif22 |
What i want to get is:
Field1;Field2;Diff1;Diff2 [Headers]
| 1 | 1 | Dif11 | Dif11 |
| 1 | 2 | Dif22 | Dif22 |
| 1 | 3 | Dif22 | Dif22 |
So i want to append queries (like UNION in SQL) but without having duplicates based on primary keys: Field1 and Field2 as composite keys.
Please help,
Jacek
Posted : 01/05/2021 6:06 am
Hi Jacek,
Can't you just append and then remove duplicates?
Mynda
Posted : 01/05/2021 7:18 pm
Topic starter
Hi Mynda,
thanks for help.
Can i remove duplicates based on composite keys columns?
How can i do this?
Best,
Jacek
Posted : 02/05/2021 6:52 am
You can remove duplicates based on one or more columns. Simply choose the columns before clicking Remove Duplicates.
Posted : 03/05/2021 7:02 am
Topic starter
Hi Linda,
thank you. I will check.
Best,
Jacek
Posted : 04/05/2021 2:11 am
