2 Replies Latest reply: May 22, 2015 6:10 AM by Ashwani Kumar RSS

    xml file

    Ashwani Kumar

      Hi Qlik Users,

       

      I required the latest XML file from a folder (abc) and want to put the data in a QVD.


      But i am facing  problem with the part Highlighted in bold underline below (in script)

       

      Error which i am getting : Load all (*) is not allowed in this file type

      Please tell me what i am doing wrong and how to rectify that.

       

      Thanks in advance

       

       

       

       

      set folder = "abc"

      ;

      for each file in filelist('$(folder)\*.xml')

       

      FileInfo:

      Load

      Distinct

      FileName() as file_name,

      FileBaseName() as file_base_name,

      FilePath() as file_path,

      FileTime() as file_time

      from

      $(file)

      (XmlSimple, Table is [entries/entry]);

      ;

      next file

      Qualify *

      ;

      LatestFiles:

      First(1)

      Load *

      resident FileInfo

      order by file_time DESC

      ;

      Drop Table FileInfo

      ;

      UNQUALIFY *

      ;

      Let source = fieldname(3, 'LatestFiles')

      ;

      Let source_i = fieldvalue('$(source)',1)

      ;

      For i = 1 to NoofRows('LatestFiles')

       

       

      [File$(i)]:

      Load *,

      '$(source_i)' as $(source)

      from

      $(source_i)

      (XmlSimple, Table is [entries/entry]) ;

      Let source_i = fieldvalue('$(source)',$(i)+1)

      ;

      next i

      exit script

      ;