topic Re: Simplify a table in App Development https://community.qlik.com/t5/App-Development/Simplify-a-table/m-p/10360#M771 <HTML><HEAD></HEAD><BODY><P>Nevermind,. I forgot the Group BY clause. </P></BODY></HTML> Mon, 26 Mar 2018 14:33:30 GMT stascher 2018-03-26T14:33:30Z Simplify a table https://community.qlik.com/t5/App-Development/Simplify-a-table/m-p/10359#M770 <HTML><HEAD></HEAD><BODY><P>Hi.&nbsp; I should lose points for asking this, it's such a simple question, but I keep getting a load error.</P><P></P><P>I have a table Table1 like:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">column_1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">column_2</TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">AA</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">BB</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">CC</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">DD</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">EE</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">FF</TD></TR></TBODY></TABLE><P></P><P>I want to create the following Table2:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">column_a</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">column_b</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">AA,BB,CC</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">DD,EE,FF</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Table2:</P><P>load distinct column_1 as column_a,</P><P>concat(column_2,',') as column_b</P><P>resident Table1;</P><P></P><P>The above doesn't work. What should I be using? </P></BODY></HTML> Mon, 26 Mar 2018 14:25:39 GMT https://community.qlik.com/t5/App-Development/Simplify-a-table/m-p/10359#M770 stascher 2018-03-26T14:25:39Z Re: Simplify a table https://community.qlik.com/t5/App-Development/Simplify-a-table/m-p/10360#M771 <HTML><HEAD></HEAD><BODY><P>Nevermind,. I forgot the Group BY clause. </P></BODY></HTML> Mon, 26 Mar 2018 14:33:30 GMT https://community.qlik.com/t5/App-Development/Simplify-a-table/m-p/10360#M771 stascher 2018-03-26T14:33:30Z