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
|CODE||NUM||NAME||WTD U||WTD U LY||MTD U||MTD U LY||STD U||STD U LY|