How do I get CONCATENATE to use the Label of ...

ux
(John Baer) #1

How do I get CONCATENATE to use the Label of a Ref column?

I am trying to create a virtual column to use as a row label in a Deck view to show multiple columns of info.

When I use my ID Ref column in CONCATENATE, it shows that actual ID number and not the Label column.

I have tried wrapping it in a TEXT() function thinking that might force the use of the Label.

To clarify, I have a Customers table.

In my CustomerOrders table I Ref the Customer ID have Name as the Label.

When I use CONCATENATE, I get the ID but I want to get Name.

(Aleksi Alkio) #2

You can read it with the Deref expression like [Customer ID].[Name]

(John Baer) #3

@Aleksi_Alkio Awesome!

Thank you!

Deref’s are new for me so didn’t think of it.