Concatenation of values in an array?

[DangIT]

Hi,

I have the following table that is generated by a transpose statement:

ID PrdGrp_1 PrdGrp_2 Prd_Grp_3 etc..

1 1 . .

2 1 3 .

3 2 4 9

etc.

The above will have PrdGrp_n based on the transactional data prior to the transpose step.

I am looking to create a variable that concatenates PrdGrp_1 to PrdGrp_n separated by '-' so it would look something like this.

ID PrdGrp_1 PrdGrp_2 Prd_Grp_3 Description

1 1 . . 1

2 1 3 . 1-3

3 2 4 9 2-4-9

etc.

Your help is greatly appreciated, thank you!

[Reeza · Accepted solution]

CATX using of to reference array.

CATX ("-", of array(*));

[Haikuo]

Just a note, you don't have to put them into an array in order to concatenate them:

Desp=catx('-', of Prodgrp:);
or 
Desp=catx('-', of prodgrp_1-prodprp_3);

And be aware, this method is more tolerant than Array method, you won't get warning if you mix up Char variables with Num variables.