Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Preceeding load error

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

1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

6 Replies
Highlighted

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

View solution in original post

Highlighted

Hi Priya,

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

Highlighted

Or use FOR and NEXT loop instead of wildcard

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

Highlighted
Master II
Master II

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Master
Master

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)