topic Re: Load on Load looses data in QlikView

Load on Load looses data

Michiel_QV_Fan — Tue, 15 Dec 2015 13:16:09 GMT

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

Re: Load on Load looses data

sunny_talwar — Tue, 15 Dec 2015 13:18:29 GMT

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

Re: Load on Load looses data

rwunderlich — Tue, 15 Dec 2015 14:42:09 GMT

Can you post the LOAD statement?

-Rob

Re: Load on Load looses data

Michiel_QV_Fan — Wed, 16 Dec 2015 12:11:03 GMT

Yes

Re: Load on Load looses data

Michiel_QV_Fan — Wed, 16 Dec 2015 12:15:09 GMT

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

rubenmarin — Wed, 16 Dec 2015 12:18:00 GMT

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

So in this script:

LOAD *;

LOAD * Inline [

Row

];

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

rubenmarin — Wed, 16 Dec 2015 12:29:44 GMT

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.

Re: Load on Load looses data

effinty2112 — Wed, 16 Dec 2015 14:28:39 GMT

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?

Re: Load on Load looses data

Michiel_QV_Fan — Wed, 16 Dec 2015 14:30:34 GMT

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

rwunderlich — Wed, 16 Dec 2015 15:13:55 GMT

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

Re: Load on Load looses data

Michiel_QV_Fan — Thu, 17 Dec 2015 10:22:00 GMT

Hi Rob,

I'm sorry but I cannot elaborate more because there isn't more. The preceding load statement is just those 2 ID's and I do load all fields in the first load.

32 bit has shown some weird things in the past (at least in my work environment) so I wouldn't be surprised if we cannot point the exact error.

For example, now I have on the same development pc the strange thing that I binary load a QVW and 1 date field contents changes.

The date field is minus 1 day.

So a date in the datamodel qlikview = 11-12-2015 (european notation) and this qvw is binary loaded, then the date is somehow changed to 10-12-2015.

In the source data the date is 11-12-2015.

Probably best to close this question.