Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unavailable fields.

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?

6 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

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.

Not applicable
Author

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)

jagannalla
Partner - Specialist III
Partner - Specialist III

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.

Not applicable
Author

Anonymous
Not applicable
Author

If possible, please share the screenshot of the error...

Not applicable
Author

hi here is a screen shoot. hope its good enough