Opening an XML File

Tue, 03 Jan 2017 02:29:45 GMT

Hello there,

I need help with the following:

I have several XML files that I need to turn into tables. It all was going good until I realized that the XML format had an attribute that has different values results, but its exactly the same:

-<cfdi:Impuestos totalImpuestosTrasladados="1070.77" totalImpuestosRetenidos="1383.08">

-<cfdi:Retenciones>

<cfdi:Retencion importe="669.23" impuesto="ISR"/>

<cfdi:Retencion importe="713.85" impuesto="IVA"/>

the dimension in the table would look like this:

[Impuestos/Retenciones/Retencion/importe] as Impuesto1,

but as it is the same xml attribute, it only takes the first value (that would be 669.23); what QV did to load this, was creating a different table, and putting all together with a key, but this does not works when I am loading different xml files with the same script. My question is: how can I load this two values in the same table, even though they are named the same, but have different result values???

thank you, and happy new year (:

Re: Opening an XML File

Tue, 03 Jan 2017 21:57:37 GMT

Hello??? I need heeelp, pleaase

Re: Opening an XML File

rwunderlich — Wed, 04 Jan 2017 01:00:46 GMT

When loading multiple XML files, the problem is generally that the QV generated key is duplicated -- which is a problem. Take a look at my second answer in this thread \XML Keys

as to how to generate unique keys per file.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

topic Opening an XML File in App Development

Opening an XML File

Re: Opening an XML File

Re: Opening an XML File