Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple formulas

ljoo
5 - Atom

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!

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

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

Qiu_0-1639374854746.png

 

nduan
Alteryx
Alteryx

Hi @ljoo 

 

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

 

nduan_0-1639396212062.png

 

nduan_1-1639396236337.png

 

nduan_2-1639396354541.png

 

 

ljoo
5 - Atom

Thank you this worked beautifully! 

Labels