Sum diagonal values in Alteryx

[igorfv]

Hi Guys,

I hope that all are well. I need sum diagonal values in a matrix (table) with Alteryx. How do solve this problem?

Example:

Thanks!

Igor Valle

[DataNath]

How extensive is your table? In this instance you could do it with a simple multi-row formula using [C]+[Row-1:B]+[Row-2:A]. However, if you have a load of columns you may need to start looking at transformation and likely macros to handle the logic. Can you provide a screenshot/sample of the size of the live dataset if this isn’t the case?

[DataNath]

Just re-read the table based on the colouring and that actually wouldn’t work sorry! If nobody offers up a solution I’ll have a play around with this tomorrow.

[igorfv]

Hi DataNath,

Thank you for your help. My table/matrix has a maximum size of 244 rows and 100 columns.

Igor Valle

[igorfv]

I found a way but it only works for tables of equal sizes. For different sizes, it doesn't work.

[patrick_digan]

@igorfv See if the attached works for you. It took a few extra tools, but it should work for tables of different sizes. The thought is to get a rowID and ColumnID for each cell, and then sum it together do each cell. Notice that diagonals all have the same sum:

[igorfv]

Hi patrick_digan,

It's worked very well. Have a nice day!

Thak you!

Igor Valle