Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert bottom triangle of matrix to 0s

Roche
8 - Asteroid

Hi everyone

 

I have a numeric output from the market basket affinity tool and would like to set the bottom part of the matrix as 0s.  Can someone please help me understand what I am doing wrong in my R code?  

Here are screenshots of my code and the one cell output, and also an example of what the data looks like before the R code:

Roche_1-1646727325965.png

 

The top select is for the Rownames and the bottom select for the numeric output of the dataframe.

Roche_2-1646727500608.png

 

Thank you

Rouche

2 REPLIES 2
TheOC
15 - Aurora
15 - Aurora

hey @Roche 

Are you able to attach your workflow at all, with sample data, and an example of the data you are trying to produce?

Cheers,
TheOC


Bulien
Roche
8 - Asteroid

Hi there, I attach data and the flow.  Thank you for your help

Labels