Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings gentlemen and ma'ams!!!
I am trying to bring only fields that are not blank or null during a LOAD / LEFT JOIN statement, but unsuccesfully.
The code follows below:
LOAD
Customer_Shipper
,
SUM
(Teus) AS
SUMTEUS
FROM
[..\..\Qvd\CSAV_BRASIL\MercadoECSA.qvd](qvd)
;
LEFT
JOIN
LOAD
Shipper
AS Costumer_Shipper
,
[Partner Code]
FROM
[..\..\Datos Externos\CSAV_BRASIL\dicionario mercado-csav\dicionario.xls] (biff, embedded labels, table is Sheet1$
)
WHERE
NOT EXISTS(Costumer_Shipper,''
)
GROUP
BY Customer_Shipper,
[Partner Code];
and the following errors are dysplayed after running the script:
... as far as I can see, my code doesn't seem to be out of logic, and I just can't figure out what's wrong...
Could someone shed some light upon this, PLEASE???
In advance, my apologies if this is an seely question (official noob here).
Thx!!!
Hi,
you are using a SUM function and an additinal field CUSTOMER_SHIPPER or so.
That´s the reason you need a GROUP BY statement so that SUM can work correctly.
Load
Customer_Shipper
Sum(TEUS) as SumTeus
From *****
Group By Customer_Shipper;
But you are loading your data from a QVD file. Not sure at the moment if it works in this case.
Maybe you have to load the table again by a resident statement.
Good luck!
Rainer
Noted Rainer, I have totally overseem this...
Thanx again!!!