I have a QVD table and an excel file that I would like to join with the qvd table. I am using the JOIN function. The QVD table has an unique Jobnumber for each row. The Excel table has multiple rows with the same Jobnumber. Below I tried to make an example what goes wrong when I join the tables
Join (QVD) load:
Result should be:
But instead I get the following result:
The result of this is that my Salesvalue for this order is 30000 instead of 10000.