Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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