Load all records in Data Source

[Saib1]

Hi 

Is that possible to ignore the columns from the excel sheet during load 

We see the error in the vcgos1.csv file that data is not loading and getting below error.

 

When I see the excel sheet there are 2 fields which is not there in my staging table.  don’t see below 2 columns .

When I exclude these 2 red columns and load the sheet . It is getting Completion code : success.

 Is there any way to ignore the column during Load all Records.

[Sai Kumar B]

@Shohaib 

In Transform map Filed maps You can set the choice action column as ignore for specific columns 

[Saib1 · Accepted solution]

I have resolved by set this properties true.

if there are inconsistent data columns in the CSV file being imported. In this occasion, while the CSV file was expected to contain rows of 26 data columns, some rows in the file were 25.

This properties will help to skip the source unwanted column from excel sheet .

Transform Map will check the source 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727707