Good Morning,
Could someone advise nice way how to solve following problem. I have files with many small tables, each tables contains different stores and applies to different department. The problem is that department numbers are placed above tables.
First I tried to use enable transformation step, but in this case I should load data without header line (columns name) and its makes some problems:
original files have a lot of columns and if in future if file structure will be changed I will load wrong data into database.
Please see example of file in attachment
Department: 609 |
| | | | | | | | | | |
CODE | NUM | NAME | | WTD U | WTD U LY | MTD U | MTD U LY | STD U | STD U LY | |
DFR | 155 | VIENNA | 1000 | 0 | 1720 | 0 | 1720 | 0 | |
321 | LONDON | 0 | 0 | 0 | 0 | 0 | 0 | |
985 | LIVERPOOL | 0 | 0 | 0 | 30000 | 0 | 0 | |
635 | KIEV | 0 | 0 | 1100 | 0 | 1700 | 0 | |
742 | MADRID | 0 | 0 | 9000 | 0 | 0 | 0 | |
159 | ROME | 0 | 0 | 0 | 0 | 0 | 85000 | |
Subtotal | | 1000 | 0 | 11820 | 30000 | 3420 | 85000 | |
Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").