2 Replies Latest reply: Jan 3, 2017 8:00 PM by Rob Wunderlich RSS

    Opening an XML File

    Jesus Lopez

      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 (: