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").
