Multiple formulas

[ljoo]

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!

[Qiu]

@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.

[nduan · Accepted solution]

Hi @ljoo 

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

[ljoo]

Thank you this worked beautifully!