Output Column Location

[nihou]

Using the Preparation tool, Formula, to calculate a percentage in a new output column.  It automatically adds the column to the end of the existing columns.  Can I select the column location to not be at the end and to be next to the columns that I am calculating?

[atcodedog05 · Accepted solution]

Hi @nihou 

Only thing you can do is use a select tool after formula and reposition. This is the possible option.

Hope this helps 🙂

[marcusblackhill · Accepted solution]

Hey @nihou !

Well, if you have a simple workflow you can solve the problem using a select tool like @atcodedog05 said, but if you need to do more steps after the calculation, maybe you can solve inside of some tool you already use in you current workflow, because some tools like Join and Append, have a Select tool embedded.

But as default, formula tool always will create the new column after the last. If you don't know how to use Select tool to change columns order, only need to click in the field you want to move and press the arrows in upper part to move up or down the field.