topic Unavailable fields. in QlikView

Unavailable fields.

Wed, 09 May 2012 14:28:05 GMT

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?

Unavailable fields.

jagannalla — Wed, 09 May 2012 14:59:51 GMT

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.

Unavailable fields.

Thu, 10 May 2012 09:17:58 GMT

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)

Unavailable fields.

jagannalla — Thu, 10 May 2012 09:37:34 GMT

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.

Unavailable fields.

Thu, 10 May 2012 09:52:43 GMT

Unavailable fields.

Anonymous — Thu, 10 May 2012 10:33:30 GMT

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

Re: Unavailable fields.

Thu, 10 May 2012 11:26:11 GMT

hi here is a screen shoot. hope its good enough