Concatenate enumlist

[fabio_pedone]

Hi, i want to concatenate in a virtual column [myVirtualColumn] , each value of the enum_list column [myColumn] to a simple text for example “x”
if i have this value
[myColumn] = ( 1,4,6,8 )
i want [myVirtualColumn] to be : ( x1,x4,x6,x8 )

i tried the formula : concatenate ( “x”, [myColumn])
but the result is x1 ,4,6,8
how i can do ?

[Aleksi · Accepted solution]

Try it like IFS(ISNOTBLANK([MyColumn]),“x”)&SUBSTITUTE(CONCATENATE([MyColumn])," , “,” , x")

[fabio_pedone]

Thanks You, it works fine !

[Aleksi]

Your welcome