Flat File Importer Error - Number of Columns Doesnt Match
Hi – I’ve downloaded and am trying the flat file delimited import from the app store https://appstore.home.mendix.com/link/app/429/. I load the file to Queue and keep getting the error, “Number of columns does not match defined columns” … I’ve double-checked my import definition and actual file, and they both have the same number of columns. Anywhere else I can check?
Have you opened the file in notepad?
Sometimes you might have a comma at the end of each row which turns the empty space at the end of a row into an additional column.
Hope this helps
Thanks for that idea; unfortunately, I don’t see an extra character at the end of the row. My delimiter by the way is ^
As a regex is used for the splitting of columns you’ll need to escape the ^ character with a backslash.
So make sure to use the following delimiter: \^ in stead of only ^