In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Formula tool not working for my If formula for a string value

JonaV
8 - Asteroid

Hi,

 

I would appreciate some help on this issue

 

I have a formula as follows

 

Event Year (field nam)

IF [EP_Scenario]="2019Actuals" THEN "2019" ELSE IF [EP_Scenario]="2020Actuals" THEN "2020" ELSE "" ENDIF ENDIF

 

However, when I run the workflow and check the data in the Event year field there are blanks instead of the 2019 and 2020 years that I specified in the formula. Does anybody why this is happenning?

 

Thank you,

 

JV

11 REPLIES 11
JonaV
8 - Asteroid

That was it! There were white spaces in the EP_Scenario, so I used a Data Cleansing tool

 

Thanks

atcodedog05
22 - Nova
22 - Nova

😂😂

 

Anyways glad to hear it got solved ðŸ™‚

 

Happy to help 🙂

 

Cheers and Happy Analyzing 😀

Labels
Top Solution Authors