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