I have a legacy table with a strange data structure. I’m trying to make a virtual column but can’t get it to work. I don’t know if it because of the GEO table structure or simply because [Country_Geo_NO] can be a list, not just a single value. Let’s assume that is the issue.
This is in another table. There can only be ONE Geo_NO per request. The [Country_Geo_NO] is based on the Geo_NO. There can be one or MORE [Country_Geo_NO] per request. I think that is where at least part of my problem is.
The expression below:
- only shows ONE [Country_Geo_NO], even when there are multiple.
- only shows the number and not the name. I’ve tried multiple ways but can’t get the [Geo_Name] to show
CONCATENATE([Geo_NO].[Geo_Name], " – ", [Country_Geo_NO])
Thanks for pointing me to the right direction.