How to turn fieldvalue into fieldname

[#1]

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_34EEBAB39911A0D4	Name	Value
101	Uitgever	FACTURATIE
101	Opdrachttype	Leveren normale koop
101	Voorwaarde	AIF
101	Boeksoort	A
150	Uitgever	FACTURATIE
150	Opdrachttype	Leveren normale koop
150	Voorwaarde	DUD
150	Boeksoort	A
199	Uitgever	FACTURATIE
199	Opdrachttype	Leveren normale koop
199	Voorwaarde	DIO
199	Boeksoort	S

What i need is 1 row/key

how do i manage this

Thanks and regards

Lidia NL

[hic · Accepted solution]

Generic

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

HIC

[#3]

Tnx

how simple it can be,