We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
21 - Polaris

@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
Top Solution Authors