Creating Networks

[smaez]

Hello,

I'm trying to create networks/groups based on common sequences of numbers. I have thousands of transactions I needed grouped by the identifier column. However, I do not know all the number combinations because the data set is so large. I need to be able to group people so I can identify if there is a connection and mitigate/identify risk. 

Data Example:

Identifier	Name	Acct No.
123456	Jane	1234
654321	Ben	1235
112225	Kurt	6541
856740	Joe	1237
856740	Frank	1238
654321	Sarah	1239
654321	Cole	1230
654321	Amy	3210
123456	Harry	3215
856740	Jake	3258
856740	Don	8626
856740	Luke	8542
555660	Bonnie	9653
856740	Ron	7518
112225	Flynn	1234

Output I'm looking for

Identifier	No. of Accts	Acct Nos.
123456	*number of accts using identifier*	1234 6541 3258
654321	*number of accts using identifier*	1235 1547

[geraldo]

@smaez 

An example

[acarter881]

Hello, @smaez.

I believe the attached workflow is what you're looking for.