Hello! I have a large dataset that requires manual edits in individual fields and I would like to see if Alteryx can be used to make this manual edits.
The affected columns are Company Name and Partner Name. I need to change the Partner Name associated to a certain company, without replacing the Partner's Name throughout the entire sheet. Ex. ABC Company currently lists Joe Smith as the Partner Name, however I would like to change the Partner Name to John Doe. This change will affect 3 cells.
Here is the formula I am using for this:
Output Column = Partner Name
IF [Company Name]='ABC Company' THEN [Partner Name]='John Doe' ELSE [Partner Name] ENDIF
The formula does not produce an error, however, it does output a "0" in the Partner Name fields I am looking to update. When I changed the Output Column to Company Name, it deleted all values in the entire Company Name column.
Ideally I would like to determine a way to make this individual cell changes using Alteryx for many other situations in this sheet as well.
Thank you!
Solved! Go to Solution.
Hi @jhosmer002 this syntax should work
Output Column = Partner Name
IF [Company Name]='ABC Company' THEN 'John Doe' ELSE [Partner Name] ENDIF
For other changes you could build your if statement like this IF [Company Name]='ABC Company' THEN 'John Doe' ELSEIF 'BCd Company' THEN "Sarah Doe" ELSE [Partner Name] ENDIF
Or you could adopt an approach of having your manual changes in a text put and using a join to replace the key fields. I've attached a workflow to showcase this.
It worked! Thank you!