topic combination of diff. variable to create a new variable. in QlikView

combination of diff. variable to create a new variable.

Tue, 30 Jun 2015 05:52:28 GMT

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 — Tue, 30 Jun 2015 05:54:57 GMT

You need an expression to concatenate those field values:

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

Kushal_Chawda — Tue, 30 Jun 2015 05:59:01 GMT

if these are fields in scripts then do as below

load *,

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

From Table

Tue, 30 Jun 2015 05:59:11 GMT

Thanks for helping me sir Jonathan

Anonymous — Tue, 30 Jun 2015 06:20:02 GMT

In script

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

;

laod it into front end.