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