Blank column headers were found on import set

gustavo1
Kilo Contributor

Hi all,
I'm scheduling an importing set from a FTP, regarding the tests I did works perfectly, but the acid test is when I try to upload a the file provided by the client, aparently the xls file to import is generated automatically by a system and adds an extra header blank column, I mean no one person is editing the file, so when the Scheduled Import trys to pull the file into the source table it can't; I tried to do it manually and I got the error message "Blank column headers were found", so editing the xls file and deletting the extra blank column works fine, so I was wondering if possible to avoid that column since the Transform Map with a script or something.
I already tried creating into the source table a new field with no labels and mapping it but doesn't work, is there another way to get it? any advance is very welcome.
Thanks in advance.

2 REPLIES 2

Daniel Draes
ServiceNow Employee
ServiceNow Employee

The transform map will kick in in a later step, so this won't be of any help. I am not 100% sure if the import of the data fails with this error or if this is 'just' a warning. Is it a XSL file that you recieve or some kind of CSV?


I'm receving the file as XLS, and something happens while is created on the system that at the end of all the created coulms adds a new blank colum, strange hu?, so I requested to the customer to provide the same file but as CSV, and with this format I have no issues.
I know the transform map only takes the non blank columns, but the column I'm talking about contains something, I don't know what, fortunately the customer is able to provide the file on csv format.
Thanks for asking Daniel.