Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this data set "data - as is". My goal is to arrive to "data -to be". Please see the image below.
I have to use loop into script or I can use logic into field expression?
Can you help me, please?
Thanks
You can use a series of concat functions:
=concat(nome,'/')&' ('&concat(number,'/')&' '&concat(email,'/')&')'
You could also use the Only fuction for number and email if there is always one value associated, but concat will produce the same result for 1 value and accomodate multiple values.
Hope that helps.