topic Re: LOAD * FROM xml file in QlikView

LOAD * FROM xml file

samantha92 — Thu, 19 Oct 2017 12:53:10 GMT

Hiya,

I am trying to load all files from an xml file but I get an error and have to load in my fields individually - is there a different way to load * from xml?

Thanks in advance!

Re: LOAD * FROM xml file

felipedl — Thu, 19 Oct 2017 12:59:23 GMT

Hi Samantha,

The 'Table Files' wizard when loading the XML files should place all the fields already and there's no option to use '*' for XML.

What type of error are you getting because i tested with the bellow xml example:

<note>

<heading>Reminder</heading>

<body>Don't forget me this weekend!</body>

</note>

And worked just fine.

Felipe.

Re: LOAD * FROM xml file

samantha92 — Thu, 19 Oct 2017 13:03:00 GMT

Hiya,

I'm getting Load all (*) is not allowed in this file type

I am creating subroutines so didn't want to load in all files individually so I am able to reuse my subroutines for other xml files.

Re: LOAD * FROM xml file

felipedl — Thu, 19 Oct 2017 13:07:57 GMT

Yes,

As i stated, the XML parsing of Qlik doesn't allow the Load * statement.

When you use the wizard, it should get all the fields (if the XML is valid) into the load statement.

You should get something like this when using the 'Table Files':

And the following load statement with the example XML.

Felipe.

Re: LOAD * FROM xml file

samantha92 — Thu, 19 Oct 2017 13:10:26 GMT

Hiya,

Yeah I have just loaded them all in, was just wondering if it was possible to do - thanks for the help

Re: LOAD * FROM xml file

felipedl — Thu, 19 Oct 2017 13:13:59 GMT

No problem .

Re: LOAD * FROM xml file

its_rajvir — Thu, 15 Apr 2021 06:35:05 GMT

Hey!

I am trying to do the same but unable to do so. Can you explain how did you load all in?

please Help!

Thanks