- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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);
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanx a lot it worked
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
With pleasure!