Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Concatenation operator in Qlik is '&'. try like:
Load
ItemId & '-' & BomId as NewField
Concatenation operator in Qlik is '&'. try like:
Load
ItemId & '-' & BomId as NewField
ItemId&'-'&sBomId as ID
Thank you all.