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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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?

0 Replies