How can I use the Multi-Field Formula tool to multiply 1-N fields by 1,000?

Question

Hi

I have a bunch of fields (columns) that need to be multiplied by 1000 to get rid of the decimals.

I know I can setup a formula for each field, but I have a lot more fields than the example below.

Is there a way to use the Multi-Field formula to solve this simply?

TRUCKSCARSPLANESHELICOPTERSHow it is in the data set1.1232.3455.4554.651How I want it1123234554554651

Claje · Accepted Answer

Hi,

You're absolutely correct that you can use Multi_field formula to accomplish this.  The key is the option to include Dynamic or Unknown fields in this tool.

Here's an example of how to configure that tool: