Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have data like below format how to load this type of data?
can anyone explain in detail.
Chanty
Have you tried using gysbert's sample here?
yes.still am unable to achieve this
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
Hi,
Thanks for your reply.
Can you share that sample Qvw ?
See Attachment.
Regards,
Antonio