CSV load error

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

 

 

Seven 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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads