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: 
razvan_brais
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
alexdataiq
Partner - Creator III
Partner - Creator III

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.

razvan_brais
Creator III
Creator III
Author

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