Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi there. You can use CONCATENATE instead of Join.
QVD:
LOAD * FROM qvdfile;
CONCATENATE
load * from excelfile;
Hi there. You can use CONCATENATE instead of Join.
QVD:
LOAD * FROM qvdfile;
CONCATENATE
load * from excelfile;
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