Solved: LOAD * FROM xml file - Qlik Community

samantha92 · ‎2017-10-19

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!

felipedl · ‎2017-10-19

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.

View solution in original post

felipedl · ‎2017-10-19

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.

samantha92 · ‎2017-10-19

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.

felipedl · ‎2017-10-19

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.

samantha92 · ‎2017-10-19

Hiya,

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

felipedl · ‎2017-10-19

No problem .

its_rajvir · ‎2021-04-15

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