topic Re: XML Load Question: repeating nodes in QlikView

XML Load Question: repeating nodes

Fri, 10 Oct 2014 17:51:35 GMT

Hi all,

Any thoughts on how to load an XML file of the structure:

<?xml version='1.0' encoding='utf-8'?>

</columns>

<rows>

<row>

</row>

<row>

</row>

</rows>

</table>

So that the table is represented in Qlikview as:

Entity, ID

Customers,1

Orders,2

When using the generated XmlSimple statement, synthetic keys and an incorrect data model are generated.

Thoughts!?

Many thanks,

Dan

Re: XML Load Question: repeating nodes

MarcoWedel — Sat, 11 Oct 2014 00:29:31 GMT

one possible solution might be:

tabEntity:
Generic
LOAD Ceil(RecNo()/2) as RowNo,
     Pick(Mod(RecNo()-1,2)+1,'Entity','ID'),
     value
FROM [QlikCommunity_Thread_137372.xml] (XmlSimple, Table is [table/rows/row/cell]);

hope this helps

regards

Marco

Re: XML Load Question: repeating nodes

Sat, 11 Oct 2014 13:25:57 GMT

Thank you!!!

Re: XML Load Question: repeating nodes

MarcoWedel — Sat, 11 Oct 2014 13:54:17 GMT

You're welcome.

Please mark this thread answered if there are no further questions.

Thanks

Regards

Marco