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?
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.