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!
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 🙂
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 🙂