Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Generic

Load %Key_InvoiceLine_34EEBAB39911A0D4, Name, Value From Table ...;

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Generic

Load %Key_InvoiceLine_34EEBAB39911A0D4, Name, Value From Table ...;

HIC

Not applicable
Author

Tnx

how simple it can be,