xls loading into different table

razvan_brais — Mon, 19 Sep 2016 16:24:19 GMT

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

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:

Table2:

Table3:

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?

topic xls loading into different table in QlikView