Four Stars

CSV load error

Hi ,

   I am loading CSV file in to my Talend job .Load is running successfully but all the data is loading in to first field and all other fields are showing null value. CSV.pngCSV2.png

 

 

  • Data Integration
2 REPLIES
Six Stars

Re: CSV load error

Could it be caused by the file encoding?

-----------------------------------------------------------------------------------------------------------
When you like my answer, please accept it as solution and send some kudos
Ten Stars

Re: CSV load error

Usually this indicates that you have the wrong Field Separator in your tFileInputDelimited component, but yours appears correct. My only guess is that while it looks like the same character in the component config and in the file, they're different. Can you copy the delimiter from your data file to the clipboard and paste it into the Field Separator field just to verify?