topic Re: Data Load from Excel in QlikView

Data Load from Excel

konidena — Mon, 18 Jan 2016 17:02:16 GMT

Hi Team,

Please help in loading the data into qlikview with the below format

Here x is merged column for columns A, B, C, D, E

In the same way Y and Z also have columns A, B, C, D, E. Columns are same but data is different.

Thanks in advance

Regards

Srinivas

Re: Data Load from Excel

andrespa — Mon, 18 Jan 2016 17:25:32 GMT

Hi Sri,

If I understand your requeriment you should do something like this:

FACT:

LOAD

A&B&C&D&E as X

FROM

[..\..\EXCEL.xlsx]

(biff, embedded labels, table is Sheet1$)

where condition_of_merge1;

CONCATENATE(FACT)

LOAD

A&B&C&D&E as Y

FROM

[..\..\EXCEL.xlsx]

(biff, embedded labels, table is Sheet1$)

where condition_of_merge2;

CONCATENATE(FACT)

LOAD

A&B&C&D&E as Z

FROM

[..\..\EXCEL.xlsx]

(biff, embedded labels, table is Sheet1$)

where condition_of_merge3;

Hope it helps.

Cheers,

Andrés

Re: Data Load from Excel

MarcoWedel — Mon, 18 Jan 2016 23:20:58 GMT

please post an Excel sample.

regards

Marco

Re: Data Load from Excel

avinashelite — Tue, 19 Jan 2016 05:14:20 GMT

check this thread for the solution :

multi_header_pivot_import.qvw

Re: Data Load from Excel

HirisH_V7 — Tue, 19 Jan 2016 05:51:42 GMT

Hi ,

Post your file with same headers and sample data.will help.

-hirish