how to read xml files in a loop

[ali_hijazi]

hello

I got a QVW file

in the script I need to read 8000 xml files (all with the same structure)

i need to go to the folder path and read all xml files into qlikview

how can I accomplish this?

Please advise

[Gysbert_Wassenaar]

With something like this:

for each File in filelist ('C:\myxmls\*.xml')

Load* from $(File) (XmlSimple, Table is

);

next File

[ali_hijazi]

I got an error saying that Load all(*) is not allowed in this file type

Please check attached sample file

[Gysbert_Wassenaar]

Use the wizard Web Files to create a load statement for that xml file.

[ali_hijazi]

yes but I got one issue

I got 8000 xml files

some files of these might contain additional tags than others

[christophebrault]

Can you share sample ?

[#7]

Hi,

Do u want that additional tag as a field or not?

Regards,

Kabilan K.

[ali_hijazi]

Yes check attached xml file in the beginning of the conversation

[ali_hijazi]

yes some xml files may contain additional tags as fields

....

<fullName>Name of employee </fullName>

.....

another file may contain

....

<fullName>Name of employee </fullName>

.....

<newTag>new information</newTag>

[#10]

Access the menu script and search for the file by the command "FILES TABLE", load only one file so that the structure QLIKVIEW read this file and create a map. If other files have different fields, add these fields using as reference the map created in the script.

Change the the file path excluding the file name and indicate only the destination folder of all files to be loaded with the expression \ *. Xml.

If the file contains more than one table that requires connection, using the file name to create a key between the tables:

FileName (FILE) as key.