File wizard transform preview

Fri, 26 Apr 2013 14:24:23 GMT

Hi,

using the file wizard to load a .txt file, I am able to create a new column with the values I need, the field @10.

The script generated by the wizard is:

LOAD @1,

@2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10

FROM

[Journals2011.TXT]

(txt, codepage is 1252, no labels, delimiter is ';', msq, header is 13 lines, filters(

ColXtr(1, RowCnd(CellValue, 1, StrCnd(start, '!JOURNAL')), 0),

Replace(10, top, StrCnd(null))

));

It seems to work without errors but the resulting table has the tenth field empty . Why?

I attached the print screen of the wizard and the table visor.

topic File wizard transform preview in QlikView