Join problems QVD with excel file

[#1]

Dear QV users,

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

QVD:

Jobnumber/Amount/Salesvalue

10W3000/3000/10000

Excel table:

Join (QVD) load:

Jobnumber/Amount

10W3000/1500

10W3000/1750

Result should be:

Jobnumber/Amount/Salesvalue

10W3000/3000/10000

10W3000/1500/0

10W3000/1750/0

But instead I get the following result:

10W3000/3000/10000

10W3000/1500/10000

10W3000/1750/10000

The result of this is that my Salesvalue for this order is 30000 instead of 10000.

Regards,

Aissam

[jvitantonio · Accepted solution]

Hi there. You can use CONCATENATE instead of Join.

QVD:

LOAD * FROM qvdfile;

CONCATENATE

load * from excelfile;

[#3]

Hi ,

can you share a sample app?

When I do the same using inline loads it gives me desired result:

10W3000/3000/10000

10W3000/1500/-

10W3000/1750/-

Kind regards

Przemek