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