Data Load from Excel

[konidena]

Hi Team,

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

X

Y

Z

A

B

C

D

E

A

B

C

D

E

A

B

C

D

E

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

[andrespa]

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

[MarcoWedel]

please post an Excel sample.

regards

Marco

[avinashelite]

check this thread for the solution :

multi_header_pivot_import.qvw

[HirisH_V7]

Hi ,

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

-hirish