How to add a new row in Alteryx?Help.

Question

Hello All -

I would like to get help in tweaking my Alteryx workflow to get the desired result. After using various tools i have arrived the result using summarize. However i would need to add a row and zero out the amount column using an offset account at Department level.

Thanks & Regards,

Sriram TS

Capture.JPG

Sriram_ts03 · Answer

I want to add Formula that if Department 1200 is in negative - add a row with department as 1200 and account as offset and with positive amount to zero out the whole .

Emmanuel_G · Answer

@Sriram_ts03

Find in attachement the way of doing this.

Let me know if there is any issue and please do not hesitate to mark this answer as solution if it worked.

How to add a new row in Alteryx.yxmd

binu_acs · Answer

@Sriram_ts03 One way of doing this

New_row_0926.yxmd