2 Replies Latest reply: Feb 21, 2014 7:19 AM by Lidia Vonk RSS

    How to turn fieldvalue into fieldname

      I have an extraction from a xml table it's an additional extension to the invoice line

      LOAD

        %Key_InvoiceLine_34EEBAB39911A0D4,  // Key to parent table: Invoice/InvoiceLine

        Name,

        Value

      FROM $(path) invoice;

       

      delivers

       

      %Key_InvoiceLine_34EEBAB39911A0D4NameValue
      101UitgeverFACTURATIE
      101OpdrachttypeLeveren normale koop
      101VoorwaardeAIF
      101BoeksoortA
      150UitgeverFACTURATIE
      150OpdrachttypeLeveren normale koop
      150VoorwaardeDUD
      150BoeksoortA
      199UitgeverFACTURATIE
      199OpdrachttypeLeveren normale koop
      199VoorwaardeDIO
      199BoeksoortS


      What i need is 1 row/key

      how do i manage this


      Thanks and regards

      Lidia NL