Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
16 - Nebula
16 - Nebula

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

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
Roche
8 - Asteroid

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

Labels
Top Solution Authors