Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Im just beginning with qvd but there is one problem as i reload some my fields and are unavailable. could someone please explain to me why this is as such?
Please check whether your qvd file is created properly with data or not. While selecting qvd file from qvw file -> edit script it will pop up File Wizard: Check whether your fields are existing or not.
Jagan here is a sample of a table i tried to QVD so i just would like to know if its correct. Because it still seems to reload unavailable fields.
LOYTRYN:
LOAD @1 as BranchNo,
@2 as TransactionDate,
(Date(Date#(@2,'YYYYMMDD'),'DD/MM/YYYY')) as %_DateKey,
@3 as MemberNo,
@4 as Reference,
@5 as Line,
@6 as StockCode,
@7 as BarCode,
@8 as Nappicode,
@9 as Department,
@10 as Description,
@11 as Bin,
@12 as Quantity,
@13 as Sales,
@14 as LineValue,
@15 as PointsPeriodNo14,
@16 as PromoPoints,
@17 as Sponsor,
@18 as PointsType,
@19 as PointsValue,
@20 as PromoFactor,
@21 as PromoPointType,
@22 as PromoPointValue,
@23 as NetItem,
@24 as CardCode,
@25 as Comment
FROM
LOYTRN_Durbell.CSV
(txt, codepage is 1252, no labels, delimiter is ',', msq);
store LOYTRYN into C:\QVD'S\LOYTRN_Durbell.CSV.qvd(qvd)
Your script looks perfectly. Can you add semicolumn at the end of qvd generation.
store LOYTRYN into C:\QVD'S\LOYTRN_Durbell.CSV.qvd(qvd);
otherwise can you share your qvw file with sample csv file.
If possible, please share the screenshot of the error...
hi here is a screen shoot. hope its good enough