Skip to Content
0
Former Member
Feb 08, 2018 at 09:28 AM

ETL Job failing when reading CSV file

241 Views Last edit Feb 08, 2018 at 09:31 AM 2 rev

Hi Team,

For the below error, can anyone suggest a solution? if we edit the file and going to 16776 record and shuffling the records upside down then the job is running fine without issues. Please assist.

A row delimiter was seen for row number <16776> while processing column number <1> in file <E:/Job_Exec_Repo/PRJ_SFDC_LEAD_HANA/DATAFILES/TE_eloqua_extract_analytics020818.txt>. The row delimiter should be seen after <23> columns. Check the file for bad data, or redefine the input schema for the file by editing the file format in the UI

Thanks,

Abdulrasheed.