Field Data Type not getting

[#1]

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

[jonathandienst]

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.