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!

2 Likes

Variables are not supported in Transformations at this time.

2 Likes

Hi, Do you know if this feature is in the pipeline, and if so, when can we expect it?
thanks

1 Like

I would like to have this feature as well. Is it planned ? or will be any time soon ?

Also need this feature. To be able to access variables in transformations

See this post

1 Like

Also need this feature to be able to access variables in transformations