Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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