topic Re: XML Load same attributes in QlikView

XML Load same attributes

bramvdpoel — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to load an xml file into qlikview, this it self doesnt form a problem. But some key field have multiple attributes with the same field name.

XML example:

Result now:

id	afbeelding
MSN-1362211	https://***/images/Naaldvilt matten set.jpg
MSN-1362211	https://***/images/MSN-1362211.jpg

What i would like:

id	Afbeelding1	Afbeelding2
MSN-1362211	https://***/images/Naaldvilt matten set.jpg	https://***/images/MSN-1362211.jpg

Can anyone help please?

Re: XML Load same attributes

Anil_Babu_Samineni — Fri, 06 Dec 2019 10:46:08 GMT

Perhaps this?

XMLData:
LOAD id,
RowNo() as Status,
afbeelding
FROM
[https://community.qlik.com/t5/New-to-QlikView/XML-Load-same-attributes/m-p/1654918#M384350]
(html, utf8, embedded labels, table is @1);

FinalTable:
LOAD Distinct id
Resident XMLData;

FOR i = 1 to FieldValueCount('Status')

LET vField = FieldValue('Status', $(i));

Left Join (FinalTable)
LOAD id,
afbeelding as [afbeelding $(vField)]
Resident XMLData
Where Status = $(vField);

NEXT i;

DROP Table XMLData;

Re: XML Load same attributes

Brett_Bleess — Mon, 16 Dec 2019 21:41:52 GMT

Did Anil's suggestion work to solve your use case? If so, do not forget to return to your post and use the Accept as Solution button on his post to give him credit for the assistance as well as let other Community Members know this worked. The only other solution would be to update the xml schema I believe, as that should be from where we are pulling things...

Regards,
Brett

Re: XML Load same attributes

bramvdpoel — Tue, 17 Dec 2019 12:45:59 GMT

It's definitly an option, it works but takes a lot of time when you have 35.000 rows.

But the best option so far! Thx