Hi,
I'm new to Alteryx with zero SQL background. I need help creating a custom filter on the Filter in-DB tool. I wanted to filter strings ending in certain characters. For example: the list contains 12A, 13B, 14C, 15D. I only want those ending in 'B' and 'C'.
Thanks in advance.
Solved! Go to Solution.
Hello @Kryjathic ,
This will help or give you idea.
Let me know if you have questions.
You will be able to access the data as it is referencing to my connection. Have a look at the filter.
In your Filter in-DB tool, choose Custom Filter and then Click on the Insert Fields to select your string filed. You would need a filter condition like this (if field name is STRING):
"STRING" LIKE '%B' or "STRING" LIKE '%C'