concatenate by uid unique fields

[Ksisterhen]

Hi trying to get the output from the below input

input					output
provider	fa	rod	facility		provider	fa	rod	facility
joe smith	jan doe	john smith	Columbia		joe smith	jan doe, Alex Johnson	john smith, Donald Duck	Columbia, Washington
john alexander	smith anderson	tom cruise	Denver		john alexander	smith anderson, Alex Johnson	tom cruise, Taylor Swift	Denver, Houston
michelle james	jan doe	Keith urban	Island		michelle james	jan doe, Betsy Ross	Keith urban, Phil Williams	Island, Dayton, Cleveland
maggie trace	smith anderson	Micky Mouse	Forest		maggie trace	smith anderson, Luke Gram	Micky Mouse, Kristen Elizabeth	Forest, Austin
joe smith	alex johnson	Donald Duck	Washington
john alexander	grant lyles	Taylor Swift	Houston
michelle james	jan doe	Phil Williams	Dayton
maggie trace	luke gram	Kristen Elizabeth	Austin
michelle james	Betsy Ross	Phil Williams	Cleveland

[binuacs]

@Ksisterhen One way of doing this with the summarise tool

[OllieClarke]

Hi @Ksisterhen 

In a summarize tool, group by [Provider] and concatenate the other 3 fields with ", " as the separator

[Ksisterhen]

how can i remove the duplicates related to a unique ID aka a provider. i..e how can i have the output not show Jane Doe twice for Michelle James? And Phil Williams twice as a ROD

[binuacs]

@Ksisterhen updated workflow attached

[Ksisterhen]

thank you! And for my knowledge does the summarize tool do anything in this workflow if it does not have an output connected to it?

[binuacs]

@Ksisterhen you can ignore the summarise tool, it was part of the initial workflow

[Ksisterhen]

nvm

[binuacs]

@Ksisterhen can you upload your excel input file?