Alteryx Designer Desktop Discussions

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

Filter In-DB SQL Query for multiple values in same field

RAHULMISHRA
8 - Asteroid

I want to filter 7 values within Filter In-DB which is connected to Connect In DB which pulls data from SAP HANA. Filter In-DB is for a String field "Shipping condition". But it is not working. Please see enclosed pic and help me with correct syntax.

1 REPLY 1
wdavis
Alteryx
Alteryx

Hi @RAHULMISHRA 

 

Would it work to change the syntax for this to say;

 

"Shipping Condition" LIKE '12' OR

"Shipping Condition" LIKE '13' OR

"Shipping Condition" LIKE '46' 

 

Then carry on this logic for the remaining 4.

 

Thanks

Will

Labels