In Database Tools - Filtering for Text in a Field

[SCOTTJSCOTT]

Hi,

I have a database that I connect to with the In-Database Connector and can start doing some manipulation and blending but am struggling with how I can filter the table based on Data that sits in a field.

In the example below I want to filter for PAGE_TITLE that contains the text bedtime-comp-intro

Not sure where I start or even if I can do this with the IN-Database Tools.

Any help will be appreciated.

 

[MSalvage · Accepted solution]

HI @SCOTTJSCOTT,

Yes you can definitely do this. the In-DB tools just take SQL instead of normal Alteryx formulas so in a In-DB filter try:

PAGE_TITLE like '%bedtime-comp-intro%'

Best,

MSalvage

[SCOTTJSCOTT · Accepted solution]

Thank you perfect.