Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Just updated to version 10.00.9282.8 SR4 and now some program don't work anymore.
I found out that it has to do with the LOAD statement of text files.
I used to have below statement which worked ok:
LOAD Text(Trim(MATNR) as item
FROM
[marc.txt] ( txt, codepage 1252, embedded labels, delimiter is '|' header is 3 lines)
WHERE (WERKS='PB01')
But after the update it crashes, I recreated the statement by using the wizard and now it seems that the fieldnames have trailing blanks! so the statement becomes:
LOAD Text(Trim([MATNR ]) as item
FROM
[marc.txt] ( txt, codepage 1252, embedded labels, delimiter is '|' header is 3 lines)
WHERE ([WERKS ]='PB01')
Is there some (new) setting which defines that trailing blanks can be ignored? Otherwise I have to rebuild a big number of programs
Br
Arend
Hi Arend,
That is the default action of QlikView - it trims data coming in from files. Has been since I can remember and I started with QV7.
The setting "Verbatim" tells QlikView to override this behaviour and take the data as read - with the spaces.
Regards,
Stephen
Stephen,
I know this is the default from Qlikview for data, that's why I Set Verbatim=1.
My point is that since applying the update, this also seems to be activated for fieldnames
Arend ,
Hi,
Probably this is "correct" and the previous behaviour was a bug.
Sorry, I don't know how to change this.
Regards,
Stephen