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

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