Preceeding load error

[priyarane]

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

[sunny_talwar · Accepted solution]

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

[ramasaisaksoft]

Hi Priya,

you can use Qualify & unqualify  before and after the tables.

[sunny_talwar]

Or use FOR and NEXT loop instead of wildcard

Wildcard data loading (*.blah......)

[trdandamudi]

I think it is because of the wildcard....

[marcus_sommer]

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

[stabben23]

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)