Data contains 2 columns, expected 1

[TechLead_vikas]

Hi All,

I am trying to create data source with the help of CSV file(Separated by ; ).

Getting an error shown in below screen.

File contains only one column, however it's showing error.

Please help me for same.

Thanks,

Vikas Ambulgekar

[karthiknagaramu]

Please validate that your CSV file is in proper format.

If you open your CSV file in notepad the format should look something like as below.

"name","wsdl","description","sys_created_on"

"Amazon","http://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl","Sample Amazon web service","2010-04-06 10:40:42"

[lvardin]

First, did you set the csv delimeter in the data source properties; Second, have you check to see that the delimeter is only used to delimit and is not part of your character set used for the text you are importing?

[Nestor Paredes]

The delimiter did it for me, thank you.

[denis hoffmann]

Hi,

In ServiceNow, new Data source use a comma ',' as "csv delimiter" by default.

With this error message, you should should have one comma in your file, who split data in two columns.

as Lubomir said, try to open your data source and set a semi-colon ';' in "CSV delimiter" field.

Regards,

Denis.