Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

data retieval


Hi all,

I am having a problem using the filter tool in extracting data from a column described to contain IGF1. When i scroll through the column i can see the description but the filter cannot pull it up, i tried using the formula tool with the formula

(Contains([COMMON_NAME],"IGF" ))

This just change the column to bool "0"

Is there anyway i can work around this?


Alteryx Certified Partner
Alteryx Certified Partner

Hi @razzy can you try this syntax and see if the filter works Contains([COMMON_NAME], "IGF"). Could you share your workflow or a screen shot of the column please as well if that does not work.