Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Excel Load

Dear Guru's,

i have requirement, where i have to import data from excel as attached.

Data is in format of sheet 1 and we need the data to be in format of sheet 2.

request to let me know how to load this data, thanks in advance

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Excel Load

Dear Friends,

Found the answer ....

Table:

LOAD @1 as Country,

     @2 as State,

     @3 as Region

FROM

Data.xlsx

(ooxml, no labels, table is SystemFile, filters(

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

));

1 Reply
Not applicable

Re: Excel Load

Dear Friends,

Found the answer ....

Table:

LOAD @1 as Country,

     @2 as State,

     @3 as Region

FROM

Data.xlsx

(ooxml, no labels, table is SystemFile, filters(

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

));

Community Browser