0 Replies Latest reply: Sep 13, 2016 1:27 PM by Paul Sparrow RSS

    Table Header and Fields query

    Paul Sparrow

      Getting and error when pulling table information on a drive.  The error points to a table that does exist so not sure why the error comes up.

       

       

      The specified network name is no longer available.

      On line number: 0. On column number: 0. System ID: file://<server>/Qlikview/Data/eGaming/eGaming_FACT_ACCOUNT_ACTIVITY_TRANS.qvd.

      QvdFields_EBU:

      LOAD

        1                      AS FieldCount,

        'eGaming_FACT_ACCOUNT_ACTIVITY_TRANS.qvd'         AS QVD_Name,

        'eGaming_FACT_ACCOUNT_ACTIVITY_TRANS.qvd' & ' * ' & FieldName AS FileField,

        FieldName,

        BitOffset,

        BitWidth,

        Bias,

        NoOfSymbols,

        Offset,

        Length,

        [NumberFormat/Type] as Type,

        [NumberFormat/nDec] as nDec,

        [NumberFormat/UseThou] as UseThou,

        [NumberFormat/Dec] as Dec,

        [NumberFormat/Thou] as Thou

      FROM

        [\\<server>\Qlikview\Data\eGaming\eGaming_FACT_ACCOUNT_ACTIVITY_TRANS.qvd] (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader])