Field Data Type not getting

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

As discussed here in (Field Type not restored from QVD/QVX?) , My query here is i am loading Qvd's dynamically from one folder and i am displaying like Name of the Qvd, File Size, Data Type in dashboard but problem here is i am getting some columns data type as 'UNKNOWN' , same Columns which are having data type as Varchar in Teradata Database

My Script is as follows :

FOR each file in FileList(vShareDir&'\*.qvd')

LET vFileName = mid(file, index(file, '\', -1) + 1, 99);

QvdFields:

LOAD

1 as FieldCount,

'$(vFileName)' as [File Name],

FieldName as [Field Name],

NoOfSymbols as [No Of Symbols],

[NumberFormat/Type] as [Data Type]

FROM [$(file)] (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);

Kindly Help me Guys,

Regards,

Reddi Kishor

Re: Field Data Type not getting

jonathandienst — Tue, 18 Apr 2017 10:39:25 GMT

The data type is set when the QVD is generated, so it would be more useful if you posted that script.

But in general, QV is only loosely typed and usually does not care that much about the data type. Unless you explicitly set the type to something in the generate script, the typing will be dynamic and dependant on the first value(s) retrieved from the data source.

topic Re: Field Data Type not getting in QlikView

Field Data Type not getting

Re: Field Data Type not getting