combination of diff. variable to create a new variable.

[#1]

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

[jonathandienst · Accepted solution]

You need an expression to concatenate those field values:

     =PCINum & '-' & MDINum & '-' & BINum & '-' & SINum & '-' & Parcel & '-' & PType

[Kushal_Chawda]

if these are fields in scripts then do as below

load *,

PCINum& '-' & MDINum &'-'& BINum &'-'& SINum &'-'& Parcel&'-'& PType as Key

From Table

[#4]

Thanks for helping me sir Jonathan

[Anonymous]

In script

load PCINum &   MDINum  & BINum& SINum & Parcel  & PType as Newvariable

;

laod it into front end.