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?

[sathishkumar_go]

Hi,

Try This...

Class:
LOAD [S/N] as KEY,
[S/N] AS SN_Class,
CLASS,
[Class no],
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
FROM

(ooxml, embedded labels, table is Link);

-Sathish

[sathishkumar_go]

[Anonymous]

This way you help?

[sathishkumar_go]

[sathishkumar_go]

[sathishkumar_go]

[sathishkumar_go]

[#9]

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

[satishkurra]

Hi

One quick suggestion, Instead of Left Join we can also use ApplyMap and get the Description based on DT Number

Good Explanation Sathish G

I attached the QV application with Apply Map code and the pivot table on UI with same result what Sathish G provided

Apology if any mistakes.

Thanks

Satish