topic Re: join two fields in same table in QlikView https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411782#M566548 <HTML><HEAD></HEAD><BODY><P>Try the example below</P><P></P><P>LOAD * , SubField(ID&amp;','&amp;ID1,',') as New_field Inline [</P><P></P><P>ID,ID1</P><P>100,101</P><P>102,103</P><P>];</P></BODY></HTML> Thu, 06 Dec 2012 08:43:13 GMT sivarajs 2012-12-06T08:43:13Z join two fields in same table https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411781#M566547 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="26486" class="jive-image-thumbnail jive-image" onclick="" alt="join.png" src="https://community.qlik.com/legacyfs/online/26486_join.png" width="450" /></P><P>I have two fields in same table I want to put two fields values in one column</P></BODY></HTML> Thu, 06 Dec 2012 07:35:17 GMT https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411781#M566547 QSense 2012-12-06T07:35:17Z Re: join two fields in same table https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411782#M566548 <HTML><HEAD></HEAD><BODY><P>Try the example below</P><P></P><P>LOAD * , SubField(ID&amp;','&amp;ID1,',') as New_field Inline [</P><P></P><P>ID,ID1</P><P>100,101</P><P>102,103</P><P>];</P></BODY></HTML> Thu, 06 Dec 2012 08:43:13 GMT https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411782#M566548 sivarajs 2012-12-06T08:43:13Z Re: join two fields in same table https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411783#M566549 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>U can write a script like,</P><P></P><P>Load *</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,UniteAdiG1&amp;'#'&amp;UniteAdiG2 as NewField</P><P>From SomeTable;</P><P></P><P>Regards,</P><P>Kabilan K</P></BODY></HTML> Thu, 06 Dec 2012 08:48:48 GMT https://community.qlik.com/t5/QlikView/join-two-fields-in-same-table/m-p/411783#M566549 2012-12-06T08:48:48Z