Create Multiple Columns

Hi,
I have over 20 new columns to create all using different expressions and fields. However i don’t want to use multiple math formula one after the other.
Is there any functionality which replicates the formula tool of Alteryx in which i can write different expressions for different columns and is within one tool instead of 20?

@r_jain The Java snippet

would allow you to create multiple variables of different sorts at the same time in one node.

1 Like

Hi, the column expressions node is another possibility. In the one node you can specify multiple output columns and write a formula for each.

5 Likes

Just be aware that a limitation of the Column Expression node is that, unlike the Alteryx Formula tool, you cannot use the your newly created columns in a later calculation inside the same tool.

For example if I make a column called C that is column A*B you cannot create column D that uses column C in its calculation.

5 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.