Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
michielvandegoo
Valued Contributor

Load on Load looses data

During my development of a new data extraction I experience that in load on load data from the first column is not loaded.

If I remove the load on load the data is shown.

No typo in the load on load statement nor any transformation on the field.

Source is a QVD.

QV 11.20.12758.0409 (SR 10 on 32-bit)

Thanks

Tags (1)
10 Replies

Re: Load on Load looses data

What do you mean when you say load on load? Do you mean Preceding Load (Preceding Load‌)?

Re: Load on Load looses data

Can you post the LOAD statement?

-Rob

michielvandegoo
Valued Contributor

Re: Load on Load looses data

Yes

michielvandegoo
Valued Contributor

Re: Load on Load looses data

Rob, as basic as it's gonna get:

Load

     CLIENT_ID1,

     ClIENT_ID3;

Load

     CLIENT_ID1,

     ClIENT_ID3,

...,

....,.

.....,

etc

FROM

[path to files\1_Resources\QVD\CLIENT.qvd]

(qvd);

Re: Load on Load looses data

I never experienced that behaviour (but I didn't used SR10 32-bit either)

So in this script:

LOAD *;

LOAD * Inline [

Row

1

2

];

The Row=1 record won't be loaded? Can you check this?

Note: I created a qvd with this data and this script also works:

LOAD *;

LOAD * from Table.qvd (qvd)

Re: Load on Load looses data

Hi Michiel, that precedent load will only load CLIENT_ID1 and CLIENT_ID3 fields, why load all other fields if you only need those 2 fields?

You can try to LOAD only from qvd adding a RowNo() field to check the values of those fields in the first row, maybe the first row have those values as null() or the values have been lost in the qvd creation.

Doesn't have many sense as you said that removing precedent load works but that's also a weird behaviour with that basic script.

effinty2112
Honored Contributor

Re: Load on Load looses data

H Michiel,

Apologies if you've already realised this but there is an apparent misspelling in your script:

Load

     CLIENT_ID1,

     ClIENT_ID3; // should be CLIENT_ID3?

could this be the fly in the ointment?

michielvandegoo
Valued Contributor

Re: Load on Load looses data

Thanks for pointing that typo Andrew.

I didn't copy paste so this is not in the qlikview script. But this strange issue remains ....

Re: Load on Load looses data

Why aren't you using LOAD * in the top load statement?

Are you using a wildcard in the filename?

It's hard to say without seeing the exact statement.

-Rob

Community Browser