Start Free Trial

Alteryx Designer Desktop Discussions

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

Modify SQL Query: Update WHERE Clause not working with LOWER function

CLashae
5 - Atom

Hello, I am trying to use the dynamic input to to update the where clause in my query. However, the where clause is dependent on having the LOWER() function. For example, in the database, the data in the string I need may be upper or lower case, but I don't always know. 

 

As a result I will typically write a query like WHERE lower(field) = 'xxxxx'

CLashae_1-1642724220121.png

 

When I include the lower() function, Alteryx is not recognizing it as a WHERE clause and so this clause dos not show up in the dropdown options for 'SQL Clause to Update'.

 

Is there a way to fix this or a workaround I can use?

 

CLashae_0-1642724175610.png

 

2 REPLIES 2
ArtApa
Alteryx
Alteryx

Hi @CLashae - You need to enter this field manually. Have a look at the following example:

ArtApa_0-1642725339291.png

 

CLashae
5 - Atom

Thanks @ArtApa ! I wasn't sure if it needed to be included as the drop-down since I've never seen the drop down blank before, but pasting it in manually worked out just fine. Thanks so much for the quick reply! 😊

Labels
Top Solution Authors