Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Community,
I am using below script, but getting synthetic keys. I have same columns in all adhoc qvds. Can some one pls suggest what is wrong over here. It was worked fine but suddenly it is throwing errors.
SALE_ADHOC:
LOAD *,CUSTOMER_SHORT_NAME as INVOLVED_NAME;
lOAD *
From
'$(vCDMPathEXTQVD)ADHOC_*_13_*.qvd' (qvd);
- Priya
I think preceding load doesn't play well with WildCard in the source data. Try it with Resident LOAD
SALE_ADHOC:
lOAD *
From
'$(vCDMPathEXTQVD)ADHOC_*_13_*.qvd' (qvd);
FINALTABLE:
LOAD *,CUSTOMER_SHORT_NAME as INVOLVED_NAME
Resident SALE_ADHOC;
DROP TABLE SALE_ADHOC;
UPDATE: Check the first few comments on HIC's blog here Preceding Load
I think preceding load doesn't play well with WildCard in the source data. Try it with Resident LOAD
SALE_ADHOC:
lOAD *
From
'$(vCDMPathEXTQVD)ADHOC_*_13_*.qvd' (qvd);
FINALTABLE:
LOAD *,CUSTOMER_SHORT_NAME as INVOLVED_NAME
Resident SALE_ADHOC;
DROP TABLE SALE_ADHOC;
UPDATE: Check the first few comments on HIC's blog here Preceding Load
Hi Priya,
you can use Qualify & unqualify before and after the tables.
Or use FOR and NEXT loop instead of wildcard
I think it is because of the wildcard....
One possible reason could be that your qvd-load is an optimized load which meant there happens no (much) processing of the data - they will be simply transferred into the RAM. You could check this with an unoptimized load like:
SALE_ADHOC:
LOAD *,CUSTOMER_SHORT_NAME as INVOLVED_NAME;
lOAD * From '$(vCDMPathEXTQVD)ADHOC_*_13_*.qvd' (qvd)
where 1=1;
- Marcus
If this is the Whole code, why even do a preceeding load? Why not do the rename part in the first LOAD.
SALE_ADHOC:
LOAD *, CUSTOMER_SHORT_NAME as INVOLVED_NAME
;
From '$(vCDMPathEXTQVD)ADHOC_*_13_*.qvd' (qvd)