i have a excel data like the picture belows. i want to load this Data to new Table in our data base. the result should look like this:
number saleperson salevolume salezone
1 A 23 34ASD
2 B 43 34ASD
Can you please help me how to do that?
You can enter the number of rows to be skipped in the beginning of file by using tFileInputExcel component to load this Data to your table.
The 'salezone' field is filled in static value?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
View this on-demand webinar about APIs....