Filter in-DB last character

Question

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.

ImadZidan · Accepted Answer

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.

rituraj963 · Accepted Answer

@Kryjathic

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'