Alteryx designer Discussions

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

Find and Change

Highlighted
5 - Atom

Is it possible to do a workflow that will find all of the instances of "11223 Facility" in the Default Labor Level and have it change the Organization to "Facilities" instead of Production? The Raw data is not quite in the format we need, so I would like it (if possible) to wholesale find and make the changes.

 

workflow.png

 
Highlighted
14 - Magnetar
14 - Magnetar

Hi @cwhitehead90 

A formula tool can do this for you. Modify the existing organization field as follows:

 

IF [Default Labor Levels]="11223 Facility" THEN "Facilities" ELSE [Organization" ENDIF

Let me know if that helps

 

Cheers!

Esther

Highlighted
Alteryx Certified Partner

But with a closing square bracket instead of a quotation mark after Organization...

Highlighted
5 - Atom

Thank you so much!

Labels