Filter a Column using wildcards and LIKE

[vr_2020]

Hi,

Filter a column based on wild card characters. I want to filter values ending with ‘ABC’ from Col A in View file in Looker. 

Col A

HTLABC

MT1ABC

NN4ABC

WRFXYZ

128XYZ

Any help please?

[Dawid]

Try the Matches (advanced) filter like this:

[vr_2020]

Thanks Dawid for this filter criteria selection.

Was looking something like this  Case when col A like ‘%ABC%’ then col A end to define/restrict the data in the View file itself in Looker. And I managed to do that in the View file.