Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
poisedon
Contributor III
Contributor III

Loading XML file with same field names

I need to load data from many XML files but these XML file have some fields with same name

example:

<Object>Year 2000</Object>

(...)

<Object>Year 2001</Object>

(...)

<Object>Year 2002</Object>

(...)

When I load XML file in Qlik Sense it takes only first <object> (Year 2000) and ignore others. How solve this problem? Maybe using a particular function in the editor? Thanks.

In the editor I'm using sintax like this:

LOAD

"Main/Electronic/Object"

FROM

[lib://Fatture/*.xml]
(XmlSimple, table is Main);

2 Replies
JustinDallas
Specialist III
Specialist III

Can we get  a stripped down anonymized sample of the data?  I tried loading the XML file into a test app and it correctly recognized my fields.  So I'd like to see yours and why it would be so different.

poisedon
Contributor III
Contributor III
Author

Problem is that if you have field with same name in the load editor it takes only the argument of first in Qlik Sense!

In the example it takes only Year 2000 and nothing else