Getting Lower Diagonal Values in Alteryx

[suraj_ford]

Hello Guys,

Is there a way to get just the lower diagonal values of matrix in the Alteryx? I have a 500*500 Correlation Matrix in order to avoid duplication I need to select only lower or upper diagonal values. Any help is appreciated. 

[atcodedog05 · Accepted solution]

Hi @suraj_ford 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[suraj_ford]

Thank You very much... It worked. 

[atcodedog05]

Happy to help 🙂 @suraj_ford 

Cheers and Happy Analyzing 😀

[suraj_ford]

Hello @atcodedog05 ,

Actually my data has 686 by 685 variables, changing their fieldnames is not an option since I want to use it the field names in the later calculation as well, do you have any other method of performing this...please help

[atcodedog05]

Hi @suraj_ford 

Is it possible to share the data ?

[atcodedog05]

Hi @suraj_ford 

Here is a workflow for the task. Here is how it would look like. If you provide i can directly modify for the data.

Output: 3x4 matrix - (n-1)xn matrix

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍