RE:How to load this Data?

[Chanty4u]

Hi all,

I have data like below format how to load this type of data?

can anyone explain in detail.

Chanty

[sunny_talwar]

Have you tried using gysbert's sample here?

multi_header_pivot_import.qvw

[Chanty4u]

yes.still am unable to achieve this

[antoniotiman]

Hi Chanty,

may be :

LOAD F1 as Product,
Qu as Open_Qu,
Ra as Open_Ra,
Val as Open_Val,
Qu1 as InValue_Qu,
Ra1 as InValue_Ra,
Val1 as InValue_Val,
Qu2 as OutValue_Qu,
Ra2  as OutValue_Ra,
Val2 as OutValue_Val,
gvalue
FROM
"https://community.qlik.com/servlet/JiveServlet/download/1155194-252646/sreg.xlsx"
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Regards,

Antonio

[Chanty4u]

Hi,

Thanks for your reply.

Can you share that sample Qvw ?

[antoniotiman]

See Attachment.

Regards,

Antonio

[settu_periasamy · Accepted solution]

Hi suresh,

find attached using multi_header_pivot_import.qvw