Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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


Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: How to turn fieldvalue into fieldname

Generic

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

HIC

2 Replies
Employee
Employee

Re: How to turn fieldvalue into fieldname

Generic

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

HIC

Not applicable

Re: How to turn fieldvalue into fieldname

Tnx

how simple it can be,

Community Browser