Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula EndIf Not working in one flow but is another flow

dberroth
8 - Asteroid

Does anyone see anything wrong with this formula? I have the exact formula in another flow and it works fine, I copied it over and added more columns to a newer flow and it is erroring out. Having trouble why this works in one flow but not another?

 

 

if +[New_Reason Code3]+[New_Reason Code4]+[New_Reason Code5]+[New_Reason Code 7]+[New_Reason Code 6]+[New_Reason Code 8]+[New_Reason Code 9]+[New_Reason Code ORIG]+[New_Reason Code CNSG]+[New_Reason Code DEST]+[New_Reason Code STCC]+[New_Reason Code CMDTY_DES]+[New_Reason Code CAR_KND]+[New_Reason Code CAR_KND_ABBR] = 0 then 'OK' else 'MisMatches Found' endif

 

dberroth_0-1603484895781.png

 

10 REPLIES 10
dberroth
8 - Asteroid

Thank you all for these solutions, I am working through to see what works best. Appreciate your responses.

Labels
Top Solution Authors