Expand my Community achievements bar.

SOLVED

SEGMENT CODES AND VARIABLES

Avatar

Level 3

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:

 

SPLIT.png

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

CELLS.png

 

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

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 3

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.

vt0509_0-1718860312553.png

 



View solution in original post

3 Replies

Avatar

Correct answer by
Level 3

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.

vt0509_0-1718860312553.png

 



Avatar

Level 3

Hi,

 

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

 

I do not understand

 

Thank you!!

Avatar

Employee

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.