Loading several XML files from a folder (caricamento XML da una cartella)

[#1]

Hi everybody, I've a big problem to load several XML files from a folder.

How can I do to load every day these files???

There are some new files that are created and added in this folder everyday.

My purpose is capture these files from this folder to put in QlikView.

Thank you very much to your attention.

Ciao a tutti, ho un grosso problema nel caricare diversi file XML da una cartella.

Come posso fare per caricare questi file??

Sostanzialmente, ogni giorno vengono creati questi file e aggiunti in questa cartella.

Lo scopo è quello di andare ad catturare tutti questi file dalla cartella, ogni giorno, e caricarli in Qlikview.

Vi ringrazio per l'attenzione.

[Marcio_Campestrini]

Hi Michele

Here is the code, from gwassenaar‌ at here

for each FileExtension in 'xml'

                    for each FoundFile in filelist( Root & '\*.' & FileExtension)

                              MessageLine:

                              Load

                                        '$(FoundFile)'               as [FilenameWithPath],
                                        '$(FileExtension)'           as [Extension],
                                           other fields....  

                                              .....
                        FROM [$(FoundFile)] (XmlSimple, Table is [Messages/Message/MessageLine]);
                                        
  
                           Messages:
        
                             Load
                                   fields....

                             FROM [$(FoundFile)] (XmlSimple, Table is [Messages]);
 
                    next FoundFile

          next FileExtension

marcio