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

Visual Query Builder Criteria for starts with

cowannbell
8 - Asteroid

I'm using visual query builder and trying to figure out how the criteria field should look if I want to only see records that start with DP.

 

I know there is a STARTSWITH but that doesn't seem to work in the criteria field.

3 REPLIES 3
CharlieS
17 - Castor
17 - Castor

For that functionality, I believe you'll need to use the SQL Editor option instead of the Visual Query Builder. 

danilang
19 - Altair
19 - Altair

Hi @cowannbell 

 

The following syntax should work in the criteria field for both SQL Server and Oracle.  Replace startstring with the text you're looking for 

 

Like 'startstring%'

 

Dan

 

cowannbell
8 - Asteroid

Thank you so much, that did it.

Labels