Can I use a virtual column (a concatenation o...

(Ivie Gonzales) #1

Can I use a virtual column (a concatenation of 2 fields previously inputted) as a reference to a different table so that I can populate other data?

(Suvrutt Gurjar) #2

Hi @Ivie_Gonzales, Based on my understanding and testing , ,technically yes, you can do that.

i believe it is equivalent of a computed key. I am sure you have already considered that concatenation should create a key that

uniquely identifies the row of source table from where you will pull the data.

(Aleksi Alkio) #3

Yes, you can choose virtual column as a key column as well.

(Grant Stead) #4

@Ivie_Gonzales you can, but it’s not necessary. Whatever other information you’re trying to “pull in” you can achieve with a derefference. - Dereferences Dereferences