.txt multiple step not reading

nicolearayav — Sat, 16 Nov 2024 17:33:50 GMT

Hello team,

I work a .txt file but now the model doesnt read it:

LOAD [@1:7],
[@8:19],
[@20:26],
[@27:35],
[@36:37],
[@38:42],
[@43:51],
[@52:69],
[@70:76],
[@77:83],
[@84:90],
[@91:n]
FROM
[C:\CSS\DB\Arrival Handling\Import MTD 01.2020.txt]
(fix, codepage is 28591, no labels, filters(
Remove(Row, RowCnd(CellValue, 12, StrCnd(null))),
Remove(Row, RowCnd(CellValue, 12, StrCnd(equal, '------')))
));

ERROR:

Field not found error

Field '@1:7' not found

How can I fix this? Thank you!!

Re: .txt multiple step not reading

marcus_sommer — Thu, 28 Jan 2021 15:49:51 GMT

Just use the table-wizard again to load this file. Afterwards you could compare the new and the old load-statement - the difference should be more or less obvious and hopefully leading to the cause of the issue.

- Marcus

topic Re: .txt multiple step not reading in QlikView

.txt multiple step not reading

Re: .txt multiple step not reading