I have a UTF-8 csv file with 248,995 LF-separated lines (header included).
tFileInputDelimited reads only 248,980 data rows, no rejects.
What should I be looking for in the data? Or in the component?
Thank you, TRF.
Excel and Talend (if CSV specified) are able to keep together in one field anything between two "s, including control characters.
So even if the number of lines of a .csv file (as read in notepad++) is higher than the number of rows read with Excel are different (adjusted for headers), the data rows are correct.
Not sure what the end system does with the LF's in a field...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources
Move from On-Premises to the Cloud by following the advice of experts
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries