SOLVED
Filter In-DB SQL Query for multiple values in same field
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
RAHULMISHRA
8 - Asteroid
‎12-17-2019
01:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Datasets
- In Database
1 REPLY 1
wdavis
Alteryx Alumni (Retired)
‎12-17-2019
03:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
