Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QlikCommunity,
Is it possible to combine this value on the picture to and appear it on one table?
I want to combine this numbers on a table to look like this 205-0-4-7-29-0000
You need an expression to concatenate those field values:
=PCINum & '-' & MDINum & '-' & BINum & '-' & SINum & '-' & Parcel & '-' & PType
You need an expression to concatenate those field values:
=PCINum & '-' & MDINum & '-' & BINum & '-' & SINum & '-' & Parcel & '-' & PType
if these are fields in scripts then do as below
load *,
PCINum& '-' & MDINum &'-'& BINum &'-'& SINum &'-'& Parcel&'-'& PType as Key
From Table
Thanks for helping me sir Jonathan
In script
load PCINum & MDINum & BINum& SINum & Parcel & PType as Newvariable
;
laod it into front end.