How to use a variable in a transformation regex

I have a panel that needs to display a subset of data from another panel, based on the value of a Client variable. The data has a _time column and a column for each possible value of the Client variable:
image
I have set up a Filter By Name Transform with the following as the regex:
/_time|$Client/
image

The _time column is recognized by this regex as expected, but the Client value is not. When I hardcode the Client value into the regex (/_time|NV/), it works – just not when I use the variable. I have also tried escaping the $ character (/_time|\$Client/) but it did not work.

How can I use a variable within a transform regex?
Thanks!

1 Like

Variables are not supported in Transformations at this time.

1 Like