topic Table Format in QlikView https://community.qlik.com/t5/QlikView/Table-Format/m-p/315410#M116394 <HTML><HEAD></HEAD><BODY><P>CONCAT should help:</P><P></P><P>LOAD</P><P>Key,</P><P>CONCAT(Comment, ', ')&nbsp;&nbsp;&nbsp;&nbsp; AS Comment</P><P>FROM ....</P><P>GROUP BY</P><P>Key;</P><P></P><P>HTH<BR />Peter</P></BODY></HTML> Fri, 20 May 2011 10:05:13 GMT prieper 2011-05-20T10:05:13Z Table Format https://community.qlik.com/t5/QlikView/Table-Format/m-p/315409#M116393 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am currently having difficulty in changing a table format in a load script: -</P><P></P><P>Natural Format:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 12.75pt;"><TD class="xl22" height="17" style="width: 48pt; height: 12.75pt;" width="64">Key</TD><TD class="xl22" style="width: 48pt;" width="64">Comment</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">A</TD><TD>Test 1</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">B</TD><TD>Test 2</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">C</TD><TD>Test 3</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">D</TD><TD>Test 4</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">B</TD><TD>Test 5</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">A</TD><TD>Test 6</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">C</TD><TD>Test 7</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">A</TD><TD>Test 8</TD></TR></TBODY></TABLE><P></P><P></P><P>Required Format:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="203"><TBODY><TR><TD class="xl24" height="17" width="64">Key</TD><TD class="xl24" width="139">Comment</TD></TR><TR><TD height="17">A </TD><TD>Test 1 Test 6 Test 8</TD></TR><TR><TD height="17">B</TD><TD>Test 2 Test 5</TD></TR><TR><TD height="17">C</TD><TD>Test 3 Test 7</TD></TR><TR><TD height="17">D</TD><TD>Test 4</TD></TR></TBODY></TABLE><P></P><P></P><P>Ive tried using the peek() command but I just don't seem to be able to get it to work.&nbsp; Any advise would be very much appreciated.</P><P></P><P></P><P>Many thanks in advance.</P></BODY></HTML> Fri, 20 May 2011 09:59:23 GMT https://community.qlik.com/t5/QlikView/Table-Format/m-p/315409#M116393 2011-05-20T09:59:23Z Table Format https://community.qlik.com/t5/QlikView/Table-Format/m-p/315410#M116394 <HTML><HEAD></HEAD><BODY><P>CONCAT should help:</P><P></P><P>LOAD</P><P>Key,</P><P>CONCAT(Comment, ', ')&nbsp;&nbsp;&nbsp;&nbsp; AS Comment</P><P>FROM ....</P><P>GROUP BY</P><P>Key;</P><P></P><P>HTH<BR />Peter</P></BODY></HTML> Fri, 20 May 2011 10:05:13 GMT https://community.qlik.com/t5/QlikView/Table-Format/m-p/315410#M116394 prieper 2011-05-20T10:05:13Z Table Format https://community.qlik.com/t5/QlikView/Table-Format/m-p/315411#M116395 <HTML><HEAD></HEAD><BODY><P> Peter,</P><P></P><P>This works perfectly.&nbsp; Many thanks for your help.</P></BODY></HTML> Fri, 20 May 2011 10:27:08 GMT https://community.qlik.com/t5/QlikView/Table-Format/m-p/315411#M116395 2011-05-20T10:27:08Z