In database filter

[shiwei1679]

I'm trying to use the in database filter to select the rows where a variable contains a string.

It seems the "like" operator only works if the I'm searching for the complete string, not part of the string.

Is there anbody who can help me on this? I'm new to Alteryx and any help would apprecaited. Thanks!

-Wei 

[MarqueeCrew]

Depends on your RDBMS, but for oracle you can replace all alphas with spaces and trim it. Test the length and if the length is 1 or more, then there is other stuff in it.

LENGTH(TRIM(TRANSLATE(string1, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', ' ')))

[shiwei1679]

Hi MarqueeCrew,

Thanks a lot for you answer to my question. It seems that I did not frame my question clearlly. What I was trying is to select the rows if column A contains a specific string such as "ABC". The values of column A might take the form like "ABCDE", "CDEFG", "HIJKL" etc. In Alteryx, some SQL commands might be needed to perform this task. Any suggestions on this? Thanks!

-Wei

[LMB · Accepted solution]

write a custom filter and write:  my_var like 'ABC%'

[shiwei1679]

Hi LMB, thanks a lot! It works. 

Best,

Wei