Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolearayav
Contributor II
Contributor II

.txt multiple step not reading

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

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, '------')))
))

 

How can I fix this? Thank you!!

Labels (1)
1 Reply
marcus_sommer

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