topic Converting selective rows to column in QlikView https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1643521#M447361 <TABLE><TBODY><TR><TD>ISSUE_ID</TD><TD>CUSTOM_FIELD_NAME</TD><TD>STRINGVALUE</TD><TD>NUMBERVALUE</TD></TR><TR><TD>7553531</TD><TD>Time in Status</TD><TD>(null)</TD><TD>(null)</TD></TR><TR><TD>7553531</TD><TD>cc: Users</TD><TD>karthik</TD><TD>(null)</TD></TR><TR><TD>7553531</TD><TD>Severity</TD><TD>Blocker</TD><TD>(null)</TD></TR><TR><TD>7553531</TD><TD>Actual Time Worked (Hours)</TD><TD>(null)</TD><TD>12</TD></TR><TR><TD>7553531</TD><TD>Resolution Class</TD><TD>Out of Scope</TD><TD>(null)</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>i have a above table</P><P>where i want to map&nbsp;Severity and&nbsp;Resolution Class to&nbsp;&nbsp;STRINGVALUE and&nbsp;Actual Time Worked (Hours) to&nbsp;NUMBERVALUE .</P><P>i want to convert it into the single rows as below.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ISSUE_ID</TD><TD>Severity</TD><TD>Actual Time Worked (Hours)</TD><TD>Resolution Class</TD></TR><TR><TD>7553531</TD><TD>Blocker</TD><TD>12</TD><TD>Out of Scope</TD></TR></TBODY></TABLE> Wed, 06 Nov 2019 06:34:18 GMT kapil_rthr 2019-11-06T06:34:18Z Converting selective rows to column https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1643521#M447361 <TABLE><TBODY><TR><TD>ISSUE_ID</TD><TD>CUSTOM_FIELD_NAME</TD><TD>STRINGVALUE</TD><TD>NUMBERVALUE</TD></TR><TR><TD>7553531</TD><TD>Time in Status</TD><TD>(null)</TD><TD>(null)</TD></TR><TR><TD>7553531</TD><TD>cc: Users</TD><TD>karthik</TD><TD>(null)</TD></TR><TR><TD>7553531</TD><TD>Severity</TD><TD>Blocker</TD><TD>(null)</TD></TR><TR><TD>7553531</TD><TD>Actual Time Worked (Hours)</TD><TD>(null)</TD><TD>12</TD></TR><TR><TD>7553531</TD><TD>Resolution Class</TD><TD>Out of Scope</TD><TD>(null)</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>i have a above table</P><P>where i want to map&nbsp;Severity and&nbsp;Resolution Class to&nbsp;&nbsp;STRINGVALUE and&nbsp;Actual Time Worked (Hours) to&nbsp;NUMBERVALUE .</P><P>i want to convert it into the single rows as below.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ISSUE_ID</TD><TD>Severity</TD><TD>Actual Time Worked (Hours)</TD><TD>Resolution Class</TD></TR><TR><TD>7553531</TD><TD>Blocker</TD><TD>12</TD><TD>Out of Scope</TD></TR></TBODY></TABLE> Wed, 06 Nov 2019 06:34:18 GMT https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1643521#M447361 kapil_rthr 2019-11-06T06:34:18Z Re: Converting selective rows to column https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1643670#M447371 <P>Why not "<SPAN>cc: Users</SPAN>" as Field?</P> Wed, 06 Nov 2019 10:54:27 GMT https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1643670#M447371 Anil_Babu_Samineni 2019-11-06T10:54:27Z Re: Converting selective rows to column https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1645863#M447515 <P>See duplicate thread, locking this one from further replies:&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Development/converting-table-in-required-format/m-p/1643525#M447362" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/converting-table-in-required-format/m-p/1643525#M447362</A></P> <P>Regards,<BR />Brett</P> Tue, 12 Nov 2019 13:25:37 GMT https://community.qlik.com/t5/QlikView/Converting-selective-rows-to-column/m-p/1645863#M447515 Brett_Bleess 2019-11-12T13:25:37Z