Error in Data Source Load

[Saib1]

When i try to load the data from excel sheet getting the error 

[Saurav11]

Just dont create a field map for the troublesome columns in the transform map

Please mark answer correct/helpful based on impact

[Saib1]

Hi Saurav,

I have not created the field map for the trouble some columns.

I have 86 column in excel sheet and i am using only 9 columns in field map . 

But while loading the excel sheet due to the source contains the trouble column it is not loading. 

Is there any way to skip the trouble column  through any transform script or any other way?

[Sushma R1]

Try this As a workaround, you may create the below system property to skip the non parseable row and load the correct rows. Name: com.glide.csv.loader.ignore_non_parseable_lines Type: true | false Value: true Description: If any row in a CSV file is non parseable for whatever reason, skip loading of that row and move on to the next one. This will ignore the row that has a mismatch in column numbers and move on to the next row instead of stopping the load then and there. Hit helpful if it was 🙂

[Saurav11]

No we cannot precent using transform script But as mentioned in the above article shared create the below system property Name: com.glide.csv.loader.ignore_non_parseable_lines Type: true | false Value: true  Then you will be able to load the data Thanks

[Sushma R1]

As a workaround, you may create the below system property to skip the non parseable row and load the correct rows. Name: com.glide.csv.loader.ignore_non_parseable_lines Type: true | false Value: true Description: If any row in a CSV file is non parseable for whatever reason, skip loading of that row and move on to the next one. This will ignore the row that has a mismatch in column numbers and move on to the next row instead of stopping the load then and there. Hit helpful if it was 🙂