topic Re: xls loading into different tables in QlikView

xls loading into different tables

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

Hy guys. I have a question. I have an excel file which looks something like this:

Level 0	Level 1	Level2
Column1	Column1_1	Column1_1_1
Column2	Column2_1	Column2_1_1
Column2	Column2_2	Column2_1_2

What i want to do is to create 3 tables in which I want to insert next values:

Table 1 is obtained by iterating through the first column from the excel file and will look lije this:

Table1:

Level 0
Column1
Column2

Table2:

Level1
Column1_1
Column2_1
Column2_2

Table3:

Level2
Column1_1_1
Column2_1_1
Column2_2_2

All these 3 tables should be connected between them because I want to create a drill down through all three tables.

Ex:

Column2 - Column2_1 -Column2_1_1

-Column 2_1_1

-Column2_2 - Column2_2_1

- Column2_2_2.

Is there any way to accomplish this behavior?

Re: xls loading into different tables

alexdataiq — Mon, 19 Sep 2016 18:42:36 GMT

Well, this is kind of a "hardcoded" solution that might only work with your examples, but here it goes:

Table1:
LOAD 
  [Level 0]
FROM

(ooxml, embedded labels, table is Sheet1);


Table2:
LOAD 
     Left([Level 1], 7) as [Level 0],
     [Level 1]
     
FROM

(ooxml, embedded labels, table is Sheet1);

Table3:
LOAD 
     Left([Level 2], 9) as [Level 1],
     [Level 2]
FROM

(ooxml, embedded labels, table is Sheet1);

Regards.

Re: xls loading into different tables

razvan_brais — Tue, 20 Sep 2016 08:23:41 GMT

Thanks for your reply. I read what I wrote , and I realized that is not what I need. But anyways , Thanks.