Copy formula to columns on the right

[TomNL]

HI,

What would be an easy way to copy a formula to the right. I don't need the formula in the first couple of columns, but then I need the same in about 100 to 1000 next columns.

Thanks!

[Emil_Kos]

Hi @TomNL,

Maybe multi field formula will be useful in your scenario:

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

[atcodedog05]

@TomNL 

Phew! you have 1000 columns thats a lot.

You can use Multi Field formula tool. Refer the link below.

https://help.alteryx.com/current/designer/multi-field-formula-tool.

Hope this helps 🙂

[atcodedog05]

Hi @TomNL ,

You can additional use dynamic select tool. Formula on field number to only select Fields only after 100th position.

https://help.alteryx.com/current/designer/dynamic-select-tool

After that you can apply the common formula.

Hope this helps 🙂