topic how to make qvd for multiple source file in QlikView

how to make qvd for multiple source file

riishabhz — Wed, 25 Nov 2020 16:16:04 GMT

my script is this as you can see i have two sql table and one excel table

i want to convert this into .qvd format so i want to make 3 qvd seprately which is 2 for sql and 1 for .csv

i tried but it didnt worked so i deleted the script .

what should i do now?

dohead:
SQL SELECT *
FROM ETPStoreV55.dbo.DOHead;

doline:
SQL SELECT *
FROM ETPStoreV55.dbo.DOline;

exceltable:
LOAD Key,
Ncode,
StoreName,
Partner,
City,
Region,
Brand,
Gender,
Cat,
SubCat,
Theme,
Fashion,
StyleNO,
Color,
GradeCount,
BGrade,
PGrade,
Count,
MRP,
OrderQty,
Recd_Qty,
Sold_Qty,
[ST Ord],
[ST Rect],
Cost,
MRLVAL,
DISC,
TAX,
NetAMt
FROM
[C:\Users\r.bhardwaj\Desktop\19P_BUY.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: how to make qvd for multiple source file

andrei_delta — Wed, 03 Jul 2019 08:11:21 GMT

Hi,

Store dohead into [C:\Users\r.bhardwaj\Desktop\dohead.qvd];

Store doline into [C:\Users\r.bhardwaj\Desktop\doline.qvd];

Store exceltableinto [C:\Users\r.bhardwaj\Desktop\exceltable.qvd];

or you can use this kind of store:

store * from doline into [C:\Users\r.bhardwaj\Desktop\doline.qvd];

etc.

hope it helps,

Andrei

Re: how to make qvd for multiple source file

riishabhz — Wed, 03 Jul 2019 09:21:45 GMT

thanx a lot it worked

Re: how to make qvd for multiple source file

andrei_delta — Wed, 03 Jul 2019 09:45:55 GMT

With pleasure!