Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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.
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