SEGMENT CODES AND VARIABLES

[bcollado]

Hi all,

I need help with the following case, hope someone knows how to implement it:

We assume that in the workflow we start from a table with the following structure:

person	age	gender
Mario	18	Hombre
Diego	31	Hombre
Sergio	22	Hombre
Maria	50	Mujer
Ignacio	45	Hombre
Alberto	29	Hombre
Blanca	25	Mujer

And after that table we add a Split with two paths. Where the segment code there would have the value of Male or Female depending on the path:

 

But then I would like to add a Cells where in the segment code part I could enter the age variable:

The desired end result would be this:

person	age	gender	segmentCode
Mario	18	Hombre	Hombre_18
Diego	31	Hombre	Hombre_31
Sergio	22	Hombre	Hombre_22
Maria	50	Mujer	Mujer_50
Ignacio	45	Hombre	Hombre_45
Alberto	29	Hombre	Hombre_29
Blanca	25	Mujer	Mujer_25

Is it possible? 

Thank your very much as always

Kind regards,

Blanca

[vt0509 · Accepted solution]

Hi @bcollado ,

Check the below option in second split, and it will concatenate the value of second segment code with first. You can add any separator too in your segment code.

[bcollado]

Hi,

so you mean I should include two splits instead of one Split and one Cells?

I do not understand

Thank you!!

[vraghav]

Add an Enrichment activity to concatenate Age and existing segment code.

Carefully in the alias section mention @segmentCode and it will do the trick for you.