- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 06:25 AM
I'm doing a data import from a CSV file on an FTP server. The CSV is delimited using semicolons rather than commas, but is not otherwise out of the ordinary. When I load the file, I get an error, "data contains 1 columns, expected 27". The transforms run as they should, and the data comes into the system. Why am I getting this error?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 07:09 AM
Maybe try cutting that last row off and see if the error stops. If it does, just ignore the error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 07:25 AM
Guess that's not it; still got the error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 08:28 AM
I loaded from the "Load Data" UI page rather than the data source, so the commas were causing issues without the delimited specified as a semicolon. Once I started loading from the data source, I was able to determine that this last line is, in fact, the problem...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 06:58 AM
Hi Relliot, have you checked the format field of your data source? Is it CSV?
Thanks,
Berny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 07:24 AM
Hi Berny--yes, CSV.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2015 07:21 AM
I ran into the same problem with an import from Altiris...the quick fix was to open the file in Excel, re-save the file and retry the import. The only difference I found after re-saving the file was the date column had changed.
