Editing multiple fields at once

[wht822]

Hello,

I currently have a dataset where the first record has data in each field that contain numbers with multiple leading zeros, such as '000100' and '001500'. Is there a way to edit all fields using a multi row formula tool? I'm thinking I could identify the record that contain this data and edit it pretty easily, it's just a matter of applying this to every field.

[Aaron_Harter · Accepted solution]

HI @wht822, 

Check out the Multi-Field Formula Tool!

Knowledge Base Article: https://community.alteryx.com/t5/Alteryx-Designer/Tool-Mastery-Multi-Field-Formula/ta-p/39658

Video Overview: