https://community.qlik.com/t5/App-Development/String-field/m-p/1578741#M42200 <P>[Table2]:<BR />Load<BR />Cloth Type,<BR />Req No.,<BR />RESIDENT [Table1];</P><P>Is it possible to change the load statement above…</P><TABLE><TBODY><TR><TD><P>Cloth Type</P></TD><TD><P>Req No.</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7369183</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7369075</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7368888</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7200055</P></TD></TR><TR><TD><P>Cotton</P></TD><TD><P>7369036</P></TD></TR><TR><TD><P>Silk</P></TD><TD><P>7369173</P></TD></TR><TR><TD><P>Silk</P></TD><TD><P>7369169</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>…to make a new field named [Req No. String] that looks like this…</P><TABLE><TBODY><TR><TD><P>Cloth Type</P></TD><TD><P>Req No. String</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7369183, 7369075, 7368888, 7200055</P></TD></TR><TR><TD><P>Silk</P></TD><TD><P>7369173, 7369169</P></TD></TR><TR><TD><P>Cotton</P></TD><TD><P>7369036</P></TD></TR></TBODY></TABLE> Fri, 10 May 2019 03:02:36 GMT rickrogers 2019-05-10T03:02:36Z https://community.qlik.com/t5/App-Development/String-field/m-p/1578741#M42200 <P>[Table2]:<BR />Load<BR />Cloth Type,<BR />Req No.,<BR />RESIDENT [Table1];</P><P>Is it possible to change the load statement above…</P><TABLE><TBODY><TR><TD><P>Cloth Type</P></TD><TD><P>Req No.</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7369183</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7369075</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7368888</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7200055</P></TD></TR><TR><TD><P>Cotton</P></TD><TD><P>7369036</P></TD></TR><TR><TD><P>Silk</P></TD><TD><P>7369173</P></TD></TR><TR><TD><P>Silk</P></TD><TD><P>7369169</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>…to make a new field named [Req No. String] that looks like this…</P><TABLE><TBODY><TR><TD><P>Cloth Type</P></TD><TD><P>Req No. String</P></TD></TR><TR><TD><P>Linen</P></TD><TD><P>7369183, 7369075, 7368888, 7200055</P></TD></TR><TR><TD><P>Silk</P></TD><TD><P>7369173, 7369169</P></TD></TR><TR><TD><P>Cotton</P></TD><TD><P>7369036</P></TD></TR></TBODY></TABLE> Fri, 10 May 2019 03:02:36 GMT https://community.qlik.com/t5/App-Development/String-field/m-p/1578741#M42200 rickrogers 2019-05-10T03:02:36Z https://community.qlik.com/t5/App-Development/String-field/m-p/1578743#M42202 Try<BR />[Table2]:<BR />Load<BR />[Cloth Type],<BR />Concat([Req No.], ', ') as [Req No. String]<BR />RESIDENT [Table1]<BR />Group by [Cloth Type]<BR />; Fri, 10 May 2019 03:52:10 GMT https://community.qlik.com/t5/App-Development/String-field/m-p/1578743#M42202 Vegar 2019-05-10T03:52:10Z