Concatenating multiple values for one field

[aswinnar]

Hi All, 

I am having another requirement, where for example for a store we are showing multiple locations: 

For the store walmart for example, we have the following locations: 

Dallas, Houston, Chicago, Denver, Miami 

When making a selection of a store, we are needing to have a text object that concatenates all of these locations for that store

so if I select Walmart in the text object I should be getting: 

Dallas/Houston/Chicago/Denver/Miami

But it seems whatever I try to do I am just getting null values due to their being too many values

Can you please help resolve this

Thanks

[Vegar · Accepted solution]

Hav you tried using concat(). 

Try like this: concat(distinct [Locations], '/') 

[ramchalla]

@aswinnar if you want to see the values based on the selections, you can use the below

Replace( concat(GetFieldSelections(Location),',','/')