Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulsparrow
Contributor III
Contributor III

Table Header and Fields query

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])

0 Replies