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 ?
Solved! Go to Solution.
Try it like IFS(ISNOTBLANK([MyColumn]),โxโ)&SUBSTITUTE(CONCATENATE([MyColumn])," , โ,โ , x")
Try it like IFS(ISNOTBLANK([MyColumn]),โxโ)&SUBSTITUTE(CONCATENATE([MyColumn])," , โ,โ , x")
Thanks You, it works fine !
Your welcome
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |