https://community.qlik.com/t5/Talend-Studio/Use-header-line-and-convert-to-key-value-pairs/m-p/2306053#M77632 We would like to have a component (or, preferable: a set of standard non-custom components) which does the following: we have a CSV input file, with the following structure:<BR />Reference column1 column2 column3<BR />reference1 value1_1 value1_2 value1_3<BR />reference2 value2_1 value2_2 value2_3<BR />Now we want to convert this file into key/value pairs, according the following schema:<BR />Reference (key field name to identify the records from each other)<BR />Key (field name)<BR />Value (field value)<BR />An example output would be:<BR />REFERENCE; KEY; VALUE<BR />reference1; column1; value1_1<BR />reference1; column2; value1_2<BR />reference1; column3; value1_3<BR />reference2; column1; value2_1<BR />reference2; column2; value2_2<BR />reference2; column3; value2_3<BR />Is this possible by using standard components? Sat, 16 Nov 2024 11:58:57 GMT Anonymous 2024-11-16T11:58:57Z https://community.qlik.com/t5/Talend-Studio/Use-header-line-and-convert-to-key-value-pairs/m-p/2306053#M77632 We would like to have a component (or, preferable: a set of standard non-custom components) which does the following: we have a CSV input file, with the following structure:<BR />Reference column1 column2 column3<BR />reference1 value1_1 value1_2 value1_3<BR />reference2 value2_1 value2_2 value2_3<BR />Now we want to convert this file into key/value pairs, according the following schema:<BR />Reference (key field name to identify the records from each other)<BR />Key (field name)<BR />Value (field value)<BR />An example output would be:<BR />REFERENCE; KEY; VALUE<BR />reference1; column1; value1_1<BR />reference1; column2; value1_2<BR />reference1; column3; value1_3<BR />reference2; column1; value2_1<BR />reference2; column2; value2_2<BR />reference2; column3; value2_3<BR />Is this possible by using standard components? Sat, 16 Nov 2024 11:58:57 GMT https://community.qlik.com/t5/Talend-Studio/Use-header-line-and-convert-to-key-value-pairs/m-p/2306053#M77632 Anonymous 2024-11-16T11:58:57Z https://community.qlik.com/t5/Talend-Studio/Use-header-line-and-convert-to-key-value-pairs/m-p/2306054#M77633 Hi, <BR />Please see the KB article about <A href="https://help.talend.com/search/all?query=Converting+columns+to+rows&amp;content-lang=en" target="_blank" rel="nofollow noopener noreferrer">Converting columns to rows</A>, hope it will be helpful for you.<BR />Best regards<BR />Sabrina Thu, 04 Jul 2013 09:38:21 GMT https://community.qlik.com/t5/Talend-Studio/Use-header-line-and-convert-to-key-value-pairs/m-p/2306054#M77633 Anonymous 2013-07-04T09:38:21Z