topic Re: Preceeding load error in QlikView

Preceeding load error

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Preceeding load error

sunny_talwar — Fri, 29 Apr 2016 12:51:33 GMT

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

Re: Preceeding load error

ramasaisaksoft — Fri, 29 Apr 2016 12:52:14 GMT

Hi Priya,

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

Re: Preceeding load error

sunny_talwar — Fri, 29 Apr 2016 12:52:46 GMT

Or use FOR and NEXT loop instead of wildcard

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

Re: Preceeding load error

trdandamudi — Fri, 29 Apr 2016 12:53:48 GMT

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

Re: Preceeding load error

marcus_sommer — Fri, 29 Apr 2016 13:01:20 GMT

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

Re: Preceeding load error

stabben23 — Fri, 29 Apr 2016 13:09:33 GMT

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)