I have a dataset which one column consisting of multiple values, for example
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:
I tried the below query but it does not work.
( contains(toLowercase(val('Column1')), toLowercase(val('METRIC1'))) )
In a Prepare recipe you can use the "Extract with Regular Expression" processor, which will allow you to identify the rows that contain Metric1 in either lowercase or uppercase.
To help you with the regex expression, use the smart pattern builder and select the right values
I hope this helps.
This solution works for me ! Thanks! Additionally can you help to elaborate further what does the val() function really represents here? Cause if i tried to remove the val() function, it does not work.
Hello, good to hear! The val() function returns the value of the column whose name you give as an argument (the column named 'Column1' in your example). If you just put 'Column1' without the val(), you'll just get a String that always has a value of 'Column1', like was done for 'metric1' in your example.