Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

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