Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vchuprina
Specialist
Specialist

Separate part of table

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
CODENUMNAME WTD UWTD U LYMTD U MTD U LYSTD U STD U LY
DFR155VIENNA100001720017200
321LONDON000000
985LIVERPOOL0003000000
635KIEV001100017000
742MADRID009000000
159ROME0000085000
Subtotal 100001182030000342085000
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").
0 Replies