Multi Row Question

Emil_Kos

Hi everyone,

Usually I am trying to answer questions of people but I am stuck and I am not sure how to move forward. 

I have a table with 20m+ rows and I am looking to identify if each line is in the chain. In order to do so at least one recipient that is the same for the previous row(comma is as a separator).

This is the data set: 

request_id	Server ID	recipient
11111111111	Server 1	RecipientA,RecipientB
11111111112	Server 1	RecipientB,RecepientC
11111111113	Server 1	RecepientA,RecepientB
11111111114	Server 1	RecepientB
11111111115	Server 1	RecepientC

This is desired output:

request_id	Server ID	recipient	Output/Chain
11111111111	Server 1	RecipientA,RecipientB	Server 1
11111111112	Server 1	RecipientB,RecepientC	Server 1
11111111113	Server 1	RecepientA,RecepientB	Server 1
11111111114	Server 1	RecepientB	Server 1
11111111115	Server 1	RecepientC

I wanted to use multi row formula:

IF [Server ID]=[Row-1:Server ID] AND
[recipient]=[Row-1:recipient]
Then [Server ID] Else '' ENDIF

But it will not work in my examples. 

I wanted to use text to columns but because recipient is not always in the same order or I can have couple different recipients for each line I don't think it will be a best solution.

Please advise me with some suggestions. I am sure the answer is quite easy but I am missing something obvious. 

philipmannering

Not sure on the exact solution, but I strongly suggest you check out the Make Group Tool. So I would split to rows the [Recipient] and then use the Make Group tool with ServerID and Recipient fields. This should add a Group that identifies a member of a chain. Think it would be perfect for what you're after...

Thanks,

Philip