I found the problem: it was my mistake, I dropped the second table and I didn't see the right result.
I'm sorry and thanks to everyone who spent time to help me.
What I know now, is that the "added" records are only in memory. Wanting to have a physical table with all the records, what should I do ?
Thanks for your help
You can store the table you just created by concatenation into a qvd file.
Use the STORE keyword for this.
Try something like :
Type , all the other fields
load Customer from MY_MASTER_DATA ....
where not exists(Customer,Customer);
Store Shipmenttable into Shipmenttable.qvd (qvd);
This will generate a QVD file for your result table.
Alternatively, you can just add all the fields from Shipmenttable into a table box and export it to Excel.
Hope that helps.