Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
riishabhz
Creator
Creator

how to make qvd for multiple source file

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);

1 Solution

Accepted Solutions
andrei_delta
Partner - Creator III
Partner - Creator III

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

View solution in original post

3 Replies
andrei_delta
Partner - Creator III
Partner - Creator III

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
riishabhz
Creator
Creator
Author

thanx a lot it worked 

andrei_delta
Partner - Creator III
Partner - Creator III

With pleasure!