Multiple formulas

Hi Alteryx Community!

I have a table of timeseries data with a lot of columns (i.e., one row per timestamp, with different timeseries in each column). I want to add new columns based on existing columns (e.g. Columns3 = Column1 + Column2, etc).

I know I can do this in the Formula tool, but I have a lot of formulas/columns to add (over 20). Is there a way that I can do this in an automated way?

Thanks in advance!

Best Practices

Accepted answers

Do you have a list of equations in text format? If so, you can try something with the Dynamic Replace tool:

Dynamic Replace.yxmd

All comments

@ljoo
Usually we will use the Transpose Tool for many column problem.
If you could provide a sample data set, we will be happy to give a try.

Do you have a list of equations in text format? If so, you can try something with the Dynamic Replace tool:

Dynamic Replace.yxmd

Thank you this worked beautifully!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703