topic Make two columns one in data model in QlikView https://community.qlik.com/t5/QlikView/Make-two-columns-one-in-data-model/m-p/501946#M480722 <HTML><HEAD></HEAD><BODY><P>i wish to make Product Group and ProductGroup1 into the same column. the key here is Item.</P><P></P><P>is there any way to do this.</P><P></P><P>i have mapped the values from another table based on Cost center. The original field Product Group comes from file upload into the FACT Table that is open on the sceen.</P><P></P><P>Best</P><P>Brad</P><P></P><P><IMG alt="" class="jiveImage" height="426" src="https://community.qlik.com/legacyfs/online/48791_pastedImage_0.png" style="width: 756px; height: 425.555px;" width="756" /></P></BODY></HTML> Sat, 09 Nov 2013 17:25:26 GMT 2013-11-09T17:25:26Z Make two columns one in data model https://community.qlik.com/t5/QlikView/Make-two-columns-one-in-data-model/m-p/501946#M480722 <HTML><HEAD></HEAD><BODY><P>i wish to make Product Group and ProductGroup1 into the same column. the key here is Item.</P><P></P><P>is there any way to do this.</P><P></P><P>i have mapped the values from another table based on Cost center. The original field Product Group comes from file upload into the FACT Table that is open on the sceen.</P><P></P><P>Best</P><P>Brad</P><P></P><P><IMG alt="" class="jiveImage" height="426" src="https://community.qlik.com/legacyfs/online/48791_pastedImage_0.png" style="width: 756px; height: 425.555px;" width="756" /></P></BODY></HTML> Sat, 09 Nov 2013 17:25:26 GMT https://community.qlik.com/t5/QlikView/Make-two-columns-one-in-data-model/m-p/501946#M480722 2013-11-09T17:25:26Z Re: Make two columns one in data model https://community.qlik.com/t5/QlikView/Make-two-columns-one-in-data-model/m-p/501947#M480723 <HTML><HEAD></HEAD><BODY><P>Concatenate both fields and give alias for single column. </P><P></P><P>Ex :<STRONG> Field1 &amp; '|' &amp; Field2 as NEW_FIELD</STRONG></P></BODY></HTML> Sat, 09 Nov 2013 19:21:06 GMT https://community.qlik.com/t5/QlikView/Make-two-columns-one-in-data-model/m-p/501947#M480723 agni_gold 2013-11-09T19:21:06Z