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?