Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

xls loading into different table

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?

Labels (1)
0 Replies