Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

In Database Tools - Filtering for Text in a Field

SCOTTJSCOTT
5 - Atom

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.

  

 Alteryx Screen Shot.JPG

2 REPLIES 2
MSalvage
11 - Bolide

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
5 - Atom

Thank you perfect.

Labels