Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

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

Replace Function need help please

joffner
5 - Atom

Tried multiple ways and can't see to figure out the correct way

The below doesn't error however it's not changing the ouput, someone recommended the replace function but i can't figure that one out

 

if [MRP Controller] in ('F84','F85','F86','F87','F88','F89') then [System LT] = 14 else [System LT] endif

 

Replace([MRP Controller], 'F84', [System LT], '14')

 

2 REPLIES 2
binuacs
21 - Polaris

@joffner you need to write the formula under the field System LT not System LT2 

IF [MRP Controller] in ('F84','F85','F86','F87','F88','F89') Then 14, Else [System LT] EndIf

image.png

joffner
5 - Atom

Thank you so much! That did the trick 

Labels
Top Solution Authors