Table Transformer - Select Where Value Contains Text

[Emily Berg]

Hello Community!

Is it possible to use a table transformer to filter out criteria that "contains" text rather than being equal to text?

For example, here is SQL query for an exact match:

SELECT * FROM T1
WHERE
T1.'Fix Version/s' = (SELECT T2.'Variable' FROM T2 WHERE T2.'Index' = 1)

Is there a way for me to include a wildcard indicator or a "Like" function to the variable - i.e. Variable = "721018502*".  This would parse out every wildcard match of 721018502, not just exact matches to "721018502 V00"?

I would prefer to use the table transformer rather than the filter macro wrapped around the excerpt.

Thank you!

Emily

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Emily Berg ,

Please try this SQL query for your Table Transformer macro:

SELECT * FROM T1
WHERE
T1.'Fix Version/s' LIKE (SELECT T2.'Variable' FROM T2 WHERE T2.'Index' = 1) + "%"

And don't forget to cut your variable in the table and leave it, for example, as "721018502".

[Emily Berg]

@Katerina Kovriga _Stiltsoft_ - works perfectly, as usual!

Thank you for the always fast response!

Emily