How do i load these excel files

[#1]

I need a good model to load these 3 sheets in attached excel so I can see the relationship between these 3 tables. I wanna drill down from Description >> Class in Dimension and have Gross, Net and Cost in expression what do I do?

[#2]

S/N cant be our unique identifier. In this case please.There is no [S/N] in the database we just used it to show the numbering

[sathishkumar_go]

OK.. that is the case ClassNo is the key field

Class:
LOAD
// [S/N] as KEY,
  [S/N],
CLASS,
[Class no],
[Class no] as KEY,
GROSS,
NET
FROM

(ooxml, embedded labels, table is Classes);

HostelInfo:
LOAD
// [S/N] as KEY,
  [S/N] AS SN_HostelInfo,
HOSTEL,
Descrition,
[DT number],
Cost
FROM

(ooxml, embedded labels, table is [Hostel info]);

left join (HostelInfo)
LOAD [DT number],
Descrition as KEY
FROM

(ooxml, embedded labels, table is Link);

-Sathish

[sathishkumar_go]

[sathishkumar_go]

Hi..

You can't use the apply map. Because 1 DT have many Descrition values.

-Sathish