Find and Append multiple fields at once

Question

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

JohnJPS · Accepted Answer

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.