topic Re: How to turn fieldvalue into fieldname in QlikView https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617353#M1325891 <HTML><HEAD></HEAD><BODY><P>Tnx</P><P>how simple it can be, </P></BODY></HTML> Fri, 21 Feb 2014 12:19:07 GMT 2014-02-21T12:19:07Z How to turn fieldvalue into fieldname https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617351#M1325886 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-GB" style="font-size: 7.5pt; font-family: Arial, sans-serif;">I have an extraction from a xml table it's an additional extension to the invoice line</SPAN></P><P>LOAD </P><P>&nbsp; %Key_InvoiceLine_34EEBAB39911A0D4,&nbsp; // Key to parent table: Invoice/InvoiceLine </P><P>&nbsp; Name,</P><P>&nbsp; Value</P><P>FROM $(path) invoice;</P><P></P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;">delivers</SPAN></P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;"></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="384" style="height: 266px; width: 409px;"><TBODY><TR><TD class="xl63" height="18" width="171">%Key_InvoiceLine_34EEBAB39911A0D4</TD><TD class="xl63" style="border-left: none;" width="105">Name</TD><TD class="xl63" style="border-left: none;" width="124">Value</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">101</TD><TD class="xl64" style="border-top: none; border-left: none;">Uitgever</TD><TD class="xl64" style="border-top: none; border-left: none;">FACTURATIE</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">101</TD><TD class="xl64" style="border-top: none; border-left: none;">Opdrachttype</TD><TD class="xl64" style="border-top: none; border-left: none;">Leveren normale koop</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">101</TD><TD class="xl64" style="border-top: none; border-left: none;">Voorwaarde</TD><TD class="xl64" style="border-top: none; border-left: none;">AIF</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">101</TD><TD class="xl64" style="border-top: none; border-left: none;">Boeksoort</TD><TD class="xl64" style="border-top: none; border-left: none;">A</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">150</TD><TD class="xl64" style="border-top: none; border-left: none;">Uitgever</TD><TD class="xl64" style="border-top: none; border-left: none;">FACTURATIE</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">150</TD><TD class="xl64" style="border-top: none; border-left: none;">Opdrachttype</TD><TD class="xl64" style="border-top: none; border-left: none;">Leveren normale koop</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">150</TD><TD class="xl64" style="border-top: none; border-left: none;">Voorwaarde</TD><TD class="xl64" style="border-top: none; border-left: none;">DUD</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">150</TD><TD class="xl64" style="border-top: none; border-left: none;">Boeksoort</TD><TD class="xl64" style="border-top: none; border-left: none;">A</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">199</TD><TD class="xl64" style="border-top: none; border-left: none;">Uitgever</TD><TD class="xl64" style="border-top: none; border-left: none;">FACTURATIE</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">199</TD><TD class="xl64" style="border-top: none; border-left: none;">Opdrachttype</TD><TD class="xl64" style="border-top: none; border-left: none;">Leveren normale koop</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">199</TD><TD class="xl64" style="border-top: none; border-left: none;">Voorwaarde</TD><TD class="xl64" style="border-top: none; border-left: none;">DIO</TD></TR><TR><TD class="xl64" height="18" style="border-top: none;">199</TD><TD class="xl64" style="border-top: none; border-left: none;">Boeksoort</TD><TD class="xl64" style="border-top: none; border-left: none;">S</TD></TR></TBODY></TABLE><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;"><BR /></SPAN></P><P>What i need is 1 row/key</P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;">how do i manage this</SPAN></P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;"><BR /></SPAN></P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;">Thanks and regards</SPAN></P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;">Lidia NL<BR /></SPAN></P><P><SPAN lang="EN-GB" style="font-size: 8.5pt; font-family: Arial, sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617351#M1325886 2026-01-26T18:19:17Z Re: How to turn fieldvalue into fieldname https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617352#M1325888 <HTML><HEAD></HEAD><BODY><P>Generic</P><P>Load %Key_InvoiceLine_34EEBAB39911A0D4, Name, Value From Table ...;</P><P></P><P>HIC</P></BODY></HTML> Fri, 21 Feb 2014 12:05:03 GMT https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617352#M1325888 hic 2014-02-21T12:05:03Z Re: How to turn fieldvalue into fieldname https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617353#M1325891 <HTML><HEAD></HEAD><BODY><P>Tnx</P><P>how simple it can be, </P></BODY></HTML> Fri, 21 Feb 2014 12:19:07 GMT https://community.qlik.com/t5/QlikView/How-to-turn-fieldvalue-into-fieldname/m-p/617353#M1325891 2014-02-21T12:19:07Z