Filter in-DB last character

[Kryjathic]

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 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.

[rituraj963 · Accepted solution]

@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'