Using Operators from columns

[ciminod1]

Lets say I want to build a formula that can use an operator from a specific column.

The columns could be set up with any of the following:

Col 1     Col 2    Col 3   Col 4

1            +            8

5             -            7

3             *            6

I don't know how to reference Column 2 in a way that pulls the symbol into the formula. I want column 4 to do the math by typing something close to [Col 1][Col 2][Col 3]; however, Col 2 and 3 fail to be recognized by the formula tool.

[Luke_C]

Hi @ciminod1 

Have you looked into the dynamic replace tool? 

https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Dynamic-Replace/ta-p/121655

[binuacs · Accepted solution]

@ciminod1 One approach for this use case

[ciminod1]

I havent given Dynamic replace an attempt at this yet. I'll see if I can get it to trigger at all.

[ciminod1]

I like the idea for this specific use case. I'll have to flesh out how it would work once you start using others like > and < to build into conditionals with if statements.