Alteryx Designer Desktop Discussions

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

Replace 0 value with <1

AMCM0806
6 - Meteoroid

Hi all, 

 

I have a data set that I would like to replace 0's with <1. However, this column includes numbers like 10, 20, 30, etc. so the replace formula is changing 10 to 1<1. Is there a formula that will look for isolated 0's? 

 

Replace([Runway in years], "0", "<1") 

 

3 REPLIES 3
binuacs
20 - Arcturus

@AMCM0806  some thing like this?binuacs_0-1684785196698.png

 

nagakavyasri
12 - Quasar
AMCM0806
6 - Meteoroid

This was the simpler solution that worked. Thank you!

Labels