topic How join two fields in load in QlikView https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458709#M794269 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have load script:</P><P>FOR EACH vSheet IN 'C1','C2','C3','C4'</P><P>LOAD Data as GamData, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ItemId, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; BomId,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Name, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; QTY</P><P>FROM</P><P><C></C></P><P>(ooxml, embedded labels, table is $(vSheet));</P><P></P><P>NEXT&nbsp; </P><P></P><P>I need field = ItemId+'-'+BomId</P><P></P><P>Exmpl: ItemId is PA-16895222542</P><P>BomId is 55658</P><P></P><P>I need new field with mean&nbsp; PA-16895222542-55658</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT irmantas 2020-11-25T16:16:04Z How join two fields in load https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458709#M794269 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have load script:</P><P>FOR EACH vSheet IN 'C1','C2','C3','C4'</P><P>LOAD Data as GamData, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ItemId, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; BomId,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Name, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; QTY</P><P>FROM</P><P><C></C></P><P>(ooxml, embedded labels, table is $(vSheet));</P><P></P><P>NEXT&nbsp; </P><P></P><P>I need field = ItemId+'-'+BomId</P><P></P><P>Exmpl: ItemId is PA-16895222542</P><P>BomId is 55658</P><P></P><P>I need new field with mean&nbsp; PA-16895222542-55658</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458709#M794269 irmantas 2020-11-25T16:16:04Z Re: How join two fields in load https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458710#M794270 <HTML><HEAD></HEAD><BODY><P>Concatenation operator in Qlik is <STRONG>'&amp;'.</STRONG> try like:</P><P></P><P>Load</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemId &amp; '-' &amp; BomId as NewField</SPAN></P></BODY></HTML> Thu, 04 Jan 2018 11:38:25 GMT https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458710#M794270 tresB 2018-01-04T11:38:25Z Re: How join two fields in load https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458711#M794272 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">ItemId&amp;'-'&amp;sBomId as ID</SPAN></P></BODY></HTML> Thu, 04 Jan 2018 11:40:09 GMT https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458711#M794272 Anonymous 2018-01-04T11:40:09Z Re: How join two fields in load https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458712#M794273 <HTML><HEAD></HEAD><BODY><P>Thank you all.</P></BODY></HTML> Thu, 04 Jan 2018 12:36:06 GMT https://community.qlik.com/t5/QlikView/How-join-two-fields-in-load/m-p/1458712#M794273 irmantas 2018-01-04T12:36:06Z