We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Matrix - updating values as 0

Suvasini
7 - Meteor

Hi all, I have a matrix which I've uploaded in the yxmd file. The first column includes the origin stations and the header consists of destination stations. So while going from station MMCT to VAPI- there were 165 people. When I travel from station MMCT TO MMCT, from ADH to ADH- it should be 0 and I was able to specify that for all the common origin-destination stations. There is a 0 diagonal. Due to a requirement, all the numbers below the diagonal need to be zero too. So from station VAPI to MMCT, instead of 88 it should be 0 and likewise for all the cells below the diagonal. How can I do that? Please note that the first row is the header and not row no 1. Would appreciate any help. Thanks.

 
OriginClassMMCTADHBVIVAPIBLSTBHBRCDHDRTMNADKOTASWMMTJNDLS
MMCT1A 0016513136674433542208600126158218768711758
ADH1A0 04949201531584  1762567
BVI1A0  14173025543219431610116136557
VAPI1A88497  9292 5 24522303
BL1A64406  6127 3200696
ST1A27101971074  198284151216150983
BH1A2944831 1  6 4111952295
BRC1A23581112782919231 75525328465512819
DHD1A109172 816   1401898
RTM1A3001176 7138   55238421
NAD1A81 4  10120   4655154
KOTA1A12836921431405648224525021082874
SWM1A152 171 15159   209751
MTJ1A136341196111119733767435222127130163
NDLS1A13079746362055010361632666101517150403378676 
2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Suvasini 
Hope this is what you need.

0107-Suvasini.PNG

Qiu
21 - Polaris
21 - Polaris

@Suvasini
Let me know if this works for you and would appreciate if you could mark it as accept if it does.

Labels
Top Solution Authors