Using the Concatenating Expression to join fi...

(Tyson Carmichael (FlyTy)) #1

Using the Concatenating Expression to join fields

Hey everyone,

I have a table called locations. It has three fields, City , State and Country.

In another table called Company Details, I have a field called location. I want to combine the City and State fields from the locations table to create the dropdown values for this field.

I used this expression CONCATENATE(Locations[City], Locations[State]) in the ValidIf but it generated an invalid data constraint error.

What changes would I make for this to work?


(Aleksi Alkio) #2

Create a virtual column to your Locations table as CONCATENATE([City],"-",[State]) and then call that column with the Valid_If.

(Tyson Carmichael (FlyTy)) #3

Works perfectly. Thanks @Aleksi_Alkio

(Aleksi Alkio) #4

You’re welcome