Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Re: How do i load these excel files

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

Partner
Partner

Re: How do i load these excel files

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

Highlighted
Partner
Partner

Re: How do i load these excel files

Partner
Partner

Re: How do i load these excel files

Hi..

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

-Sathish