topic Re: how to read xml files in a loop in QlikView

how to read xml files in a loop

ali_hijazi — Thu, 25 Oct 2012 10:05:44 GMT

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

Re: how to read xml files in a loop

Gysbert_Wassenaar — Thu, 25 Oct 2012 10:25:43 GMT

With something like this:

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

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

);

next File

Re: how to read xml files in a loop

ali_hijazi — Thu, 25 Oct 2012 11:36:14 GMT

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

Please check attached sample file

Re: how to read xml files in a loop

Gysbert_Wassenaar — Thu, 25 Oct 2012 11:52:59 GMT

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

Re: how to read xml files in a loop

ali_hijazi — Thu, 25 Oct 2012 11:57:31 GMT

yes but I got one issue

I got 8000 xml files

some files of these might contain additional tags than others

Re: how to read xml files in a loop

christophebrault — Thu, 25 Oct 2012 12:09:18 GMT

Can you share sample ?

Re: how to read xml files in a loop

Thu, 25 Oct 2012 12:14:38 GMT

Hi,

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

Regards,

Kabilan K.

Re: how to read xml files in a loop

ali_hijazi — Thu, 25 Oct 2012 12:19:26 GMT

Yes check attached xml file in the beginning of the conversation

Re: how to read xml files in a loop

ali_hijazi — Thu, 25 Oct 2012 12:21:18 GMT

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>

Re: how to read xml files in a loop

Sun, 23 Jun 2013 23:52:43 GMT

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.

Re: how to read xml files in a loop

cotiso_hanganu — Mon, 01 Aug 2016 09:45:29 GMT

I think I understand your need, Ali.

We did such a project some years ago (additionally to the dynamic XML structure parsing, we had also in the script a part that was identifying the new comers fields, or the disappearing ones)

Is you request still relevant ?

Re: how to read xml files in a loop

consultant_bi — Thu, 23 May 2019 10:20:32 GMT

Hi @cotiso_hanganu

i am in need of the solution that you explained above , could you help me and thanks in advance