Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What do you mean when you say load on load? Do you mean Preceding Load (Preceding Load)?
Can you post the LOAD statement?
-Rob
Yes
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);
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)
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.
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?
Thanks for pointing that typo Andrew.
I didn't copy paste so this is not in the qlikview script. But this strange issue remains ....
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