Load issue after update to 10.00.9282.8 SR4

[#1]

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

LOAD Text(Trim([MATNR               ])) as MATNRd
FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', header is 3 lines)
WHERE([WERKS ] = 'NL11');

[stephencredmond]

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

[#3]

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 ,

[stephencredmond]

Hi,

Probably this is "correct" and the previous behaviour was a bug.

Sorry, I don't know how to change this.

Regards,

Stephen