https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331104#M100124 I also have the same requirement. I have looked at the linked topic and can get the column names displayed to the console, but that does not pivot the row to create multiple rows. <BR />Is there a mechanism for generatign the output detailed: <BR />Input Flow: <BR />------------------------------------ <BR />|ID|column1|column2|column3| <BR />------------------------------------ <BR />|10|1.23 | 234.32 |987.45 | <BR />------------------------------------ <BR />Output Flow: <BR />---------------------------------- <BR />|ID|KEY |VALUE | <BR />---------------------------------- <BR />|1 |column1 | 1.23 | <BR />---------------------------------- <BR />|2 |column2 |234.32 | <BR />---------------------------------- <BR />|3 |column3 |987.45 | <BR />---------------------------------- <BR />Thanks in advance Tue, 06 Sep 2011 11:30:31 GMT Anonymous 2011-09-06T11:30:31Z https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331101#M100121 Hi Shong, <BR /> Hope you are doing good! <BR /> I have this requirement ... <BR /> Table1 <BR />------------------------------------ <BR />|ID|column1|column2|column3| <BR />------------------------------------ <BR />|10|1.23 | 234.32 |987.45 | <BR />------------------------------------ <BR /> This Table1 will be TRANSFORMED into <BR />Table2 <BR />---------------------------------- <BR />|ID|KEY |VALUE | <BR />---------------------------------- <BR />|1 |column1 | 1.23 | <BR />---------------------------------- <BR />|2 |column2 |234.32 | <BR />---------------------------------- <BR />|3 |column3 |987.45 | <BR />---------------------------------- <BR /> <BR /> So in Simple words its a horizontal to vertical transformation where a single row (with N columns except PRIMARYKEY column ) will be transformed into N rows as key/value pairs where key=columnName and value is the Actualvalue <BR /> Can anyone please suggest me any solution on how to get "COLUMNNAME " instead of value in it! <BR /> Appreciate any thoughts/solution on this. <BR />Thanks <BR />Madhu Prasad Paridi Sat, 16 Nov 2024 13:44:57 GMT https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331101#M100121 _AnonymousUser 2024-11-16T13:44:57Z https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331102#M100122 Hello <BR />See a related 6441. <BR />Best regards <BR /> <BR /> shong Wed, 30 Sep 2009 10:40:09 GMT https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331102#M100122 Anonymous 2009-09-30T10:40:09Z https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331103#M100123 Thanks Shong!!. I Appreciate your help. <BR />Regards <BR />Madhu Prasad Paridi Wed, 30 Sep 2009 14:54:34 GMT https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331103#M100123 _AnonymousUser 2009-09-30T14:54:34Z https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331104#M100124 I also have the same requirement. I have looked at the linked topic and can get the column names displayed to the console, but that does not pivot the row to create multiple rows. <BR />Is there a mechanism for generatign the output detailed: <BR />Input Flow: <BR />------------------------------------ <BR />|ID|column1|column2|column3| <BR />------------------------------------ <BR />|10|1.23 | 234.32 |987.45 | <BR />------------------------------------ <BR />Output Flow: <BR />---------------------------------- <BR />|ID|KEY |VALUE | <BR />---------------------------------- <BR />|1 |column1 | 1.23 | <BR />---------------------------------- <BR />|2 |column2 |234.32 | <BR />---------------------------------- <BR />|3 |column3 |987.45 | <BR />---------------------------------- <BR />Thanks in advance Tue, 06 Sep 2011 11:30:31 GMT https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331104#M100124 Anonymous 2011-09-06T11:30:31Z https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331105#M100125 Try tUnpivotRow from the Exchange or tSplitRow. There are many posts about these. Wed, 07 Sep 2011 01:26:48 GMT https://community.qlik.com/t5/Talend-Studio/Retrieving-Column-Name-along-with-value/m-p/2331105#M100125 alevy 2011-09-07T01:26:48Z