Contains with Lowercase

imransaiful17
imransaiful17 Registered Posts: 10 ✭✭✭✭

Hi Team,

I have a dataset which one column consisting of multiple values, for example

Column1
Metric1,Country
METRIC1,Country
METRIC1,Country
Metric2,Country

Is there a work around to filter the values in the column to only keep the value that contains 'Metric1' regardless of the case.

The result should be:

Column1
Metric1,Country
METRIC1,Country
METRIC1,Country

I tried the below query but it does not work.
( contains(toLowercase(val('Column1')), toLowercase(val('METRIC1'))) )

Please assist.

Best Answer

Answers

Setup Info
    Tags
      Help me…