How join two fields in load

[irmantas]

Hello,

I have load script:

FOR EACH vSheet IN 'C1','C2','C3','C4'

LOAD Data as GamData,

     ItemId,

     BomId,

     Name,

     QTY

FROM

(ooxml, embedded labels, table is $(vSheet));

NEXT 

I need field = ItemId+'-'+BomId

Exmpl: ItemId is PA-16895222542

BomId is 55658

I need new field with mean  PA-16895222542-55658

[tresesco · Accepted solution]

Concatenation operator in Qlik is '&'. try like:

Load

      ItemId & '-' & BomId as NewField

[Anonymous]

ItemId&'-'&sBomId as ID

[irmantas]

Thank you all.