Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vchuprina
Not applicable

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