This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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,NetAMtFROM[C:\Users\r.bhardwaj\Desktop\19P_BUY.xlsx](ooxml, embedded labels, table is Sheet1);
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:
View solution in original post
thanx a lot it worked