In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Comparing Records between two fields

nfoong
7 - Meteor

Hi,

 

I have the following sample and would like to convert it to the next table below, which shows that if the 2 routes have the same supplier, show the number of common suppliers between both routes. Hope that makes sense.

 

Thanks.

 

SupplierRoutes
ARoute 1
BRoute 2
BRoute 3
CRoute 2
CRoute 3
DRoute 4
ERoute 1

 

 Route 1Route 2Route 3Route 4
Route 1x   
Route 2 x1 
Route 3 1x 
Route 4   x
2 REPLIES 2
Joe_Mako
12 - Quasar

How about something like the attached?

 

Also what is the logic to get 1 instead of 2 for the the number of suppliers with both Routes 2 and 3?

skalgaonkar
6 - Meteoroid

I realize this is a few years later, but I was recently looking to resolve a similar issue and your solution helped.  Thank you!

Labels
Top Solution Authors