xls loading into different tables

[razvan_brais]

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

Level 0	Level 1	Level2
Column1	Column1_1	Column1_1_1
Column2	Column2_1	Column2_1_1
Column2	Column2_2	Column2_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?

[alexdataiq]

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]

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