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
アステロイド

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件の返信10
dberroth
アステロイド

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

ラベル