Can I ignore blank rows in an import?

[KB15]

I have a CSV that has blank rows at the end. The import fails because it expected x number of columns. DBAs seem they can't control this on their export. I have my doubts.

Can do anything on the ServiceNow end to ignore blank rows during the import process? Would I also have to do the same for the transform to ignore blank records?

Just for clarification, this is during the load and not the transform. The export from the SQL query has blank rows and when ServiceNow loads it into a table, it will error at the end because it expects more than one column. You wouldn't be able to run any transform rules to work around it.

[sachin_namjoshi]

You can ignore rows with empty data using transform script in your transform map.

if(source.u_field1 == '' && source.u_field2 == '' && source.u_field3 == '')


  {


  ignore = true;


  }

Regards,

Sachin

[Akshay H Mulky]

Hi,

This could help you:

https://exceljet.net/lessons/how-to-quickly-remove-blank-rows

[KB15]

This is through an automated export so I wouldn't have any control over it unfortunately.

[sachin_namjoshi]

How are you processing these exports?

You must have some data sources, trasnform map , API to process these imports?

Regards,

Sachin