Network Detection?

[aweiss2k]

Hi, I'm trying to figure the most efficient way (if possible) to use Alteryx for network basic network (edge and node) detection/coding.  I have datasets that contain data like this (except millions of records):

I want to be able to have Alteryx identify and tag which transactions are in a connected network.  So, in this case, transactions 1-5 are all in network "1", and transactions 6-10 are in network "2" and to output that network number as a new field value ("Network Number") at the end of each row.  I've messed with the Network Analysis tool but that doesn't seem to fit the bill for what I need.  Is there another tool that would work?

Thanks,

Aaron

[christine_assaad]

Hello @aweiss2k 

Have you checked 'Make Group' tool which is part of the Join category? I worked on your data in the attached file. Hope this is what you are looking for. Cheers!