Adding a new row and then doing operations on the rows.

[Sumit_Anand]

HI ,

I am new to Alteryx and kind of need help.

I have a table as shown in fig 1. I want to add one new row (say Z) where i want to custom formula on the corresponding columns, as shown in fig2.

Please let me know how to do this in the designer.

[afv2688 · Accepted solution]

Hello @Sumit_Anand ,

The best way would be to process that specific row separately and add it afterwards to the table.

You could also give specific functions to a row when given certain conditions (basically adding an if else to the table)

Regards