Alteryx Designer Desktop Discussions

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

Multi Field Formula Creates New Columns Instead of Overwriting

shaheer
8 - Asteroid

Let's say I have the following table:

 

Name
Adams, Jacob
Holiday, Jrue

 

I have a multi field formula tool that changes the names ordering around, but a new column is created rather than overwriting. For example:

 

NameNew Name
Adams, JacobJacob Adams
Holiday, JrueJrue Holiday

 

How do I overwrite? Here is my formula:

 

shaheer_0-1665760727962.png

 

 

 

1 REPLY 1
binuacs
20 - Arcturus

@shaheer You need to select the update existing field option and and select Name field instead of going with new field in the multi-row tool.

Labels