I'm using the Concat(City, ',') expression.
I'm actually looking for the reverse option as well.
when we have a record with the following values 'Kansas, Utah, Alabama'.
Is there a way to use string manipulation with a comma or comma delimited to get every value out of this into a table.
Rob, thanks for the reply
I know it works with subfield when you hardcoded.
I tried subfield(City, ',') but that only gives the first value Kansas.
the problem is: today the concatenated table contains 3 cities, tomorrow that could be 12 cities.
So hardcoding the cities into the expression is not a solution, it should be dynamic
You can see an example of this case in my answer to this post:
There is also another example (from Sridhar) in the same thread which shows Rob's suggestion
Hope this helps,
I have for example 2 tables with following values
State City concatenated field
Alabama Huntsville Alabama, Huntsville
Alabama Hoover Alabama, Hoover
Alabama Dothan Alabama, Dothan
Kansas Topeka Kansas, Topeka
Kansas Manhattan Kansas, Manhattan
Kansas Salina Kansas, Salina
Utah Salt Lake city Utah, Salt Lake city
Utah Layton Utah, Layton
Utah Provo Utah, Provo
The problem I have now is that it's not possible to click on the City or State within the Concatenated field.
Is that even possible to click on a value withing a field, meaning If I click on Alabama within the Concatenated field that the 2 other tables change values as well?