Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

xls loading into different tables

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

Level 0Level 1Level2
Column1Column1_1Column1_1_1
Column2Column2_1Column2_1_1
Column2Column2_2Column2_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?

2 Replies
Highlighted
Partner
Partner

Re: xls loading into different tables

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.

Highlighted
Creator III
Creator III

Re: xls loading into different tables

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