We have requirement where we need to process and load a file without column heading and may be field seperater for all column also will not there for each row.
For exampleuppose we have table TAB1 with five coulmns and following input files need to load into that table.
Input File :
If you see third row is not having complete data and field seperator .As we have five columns thus four feild seperator is must to maintain data for each columns.
If we process this type of file with DYNAMIC schema (bec we need to process so many files and not sure about file structure) then we are getting error.
However,once we correct the input file and provide all database column names as header and complete third row data with filed seperator then that file process successfully.
So we need assistance to process this type of file where column heading will not exist and data and field seperator also will not exist for each column.
Please assist ,How to load this type of file with DYNAMIC schema type.
Tag as "solved" for others! Kudos to thanks!
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.