Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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