Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Conditional Formula with Contains Issue

Link86
8 - Asteroid

Hi,

I am not sure why my formula is not working. I am hoping someone here can help me troubleshoot it. 

 

I am trying to recode a group where the word "Macro" will show up if the Group is null and the ToolName contains ".yxmc". Not sure why this is not working. I have attached screenshots and a two tool sample workflow if it helps. The sample workflow will not match the screen shots because the screenshots come from the workflow that I need to have this work with. Sadly, I cannot share that workflow due to sensitive information.

 

Thank you for your help with this. I am sure it's something very minor that I am overlooking.

 

Capture.JPGCapture2.JPG

  

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Link86 ,

 

change the order of [Field] and 'string' in the Contains function to Contains([ToolName], '.yxmc') and it should work as expected.

 

Let me know if it works for you.

 

Best,

 

Roland

Link86
8 - Asteroid

Oh my goodness. I knew it was something I was overlooking. Thank you!

Labels
Top Solution Authors