Find and Append multiple fields at once

[bryanmason19]

Hi All,

I am in the process of updating a portion of the data in my workflow. I have a list of account numbers that need to be updated which I have done using a find and replace tool. In addition to replacing the account number I also need to update the customer name, DUNS Domestic, and DUNS global. Is there a way where I can find and replace all of these fields at once?

Thanks 

[paul_houghton]

Have you tried using the dynamic rename tool?

You can use that to rename fields based on a formula, whats in the first row of data, or an alternative list from a data input.

[JohnJPS · Accepted solution]

Hi Bryan,

Typically I would try to use a join... if the first approach to getting the tables matched up is to do a find replace, you should then be able to follow that with a join in order to pick up any additional fields; and then select whatever values you want from each table. I've attached a workflow that hopefully may help.