Hi trying to get the output from the below input input output providerfarodfacility providerfarodfacilityjoe smithjan doejohn smithColumbia joe smithjan doe, Alex Johnsonjohn smith, Donald DuckColumbia, Washingtonjohn alexandersmith andersontom cruiseDenver john alexandersmith anderson, Alex Johnsontom cruise, Taylor SwiftDenver, Houstonmichelle jamesjan doeKeith urbanIsland michelle jamesjan doe, Betsy RossKeith urban, Phil WilliamsIsland, Dayton, Clevelandmaggie tracesmith andersonMicky MouseForest maggie tracesmith anderson, Luke GramMicky Mouse, Kristen ElizabethForest, Austinjoe smithalex johnsonDonald DuckWashington john alexandergrant lylesTaylor SwiftHouston michelle jamesjan doePhil WilliamsDayton maggie traceluke gramKristen ElizabethAustin michelle jamesBetsy RossPhil WilliamsCleveland

concatenate by uid unique fields

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

Developer

Accepted answers

All comments

binu_acs

@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

concat.yxmd

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

binu_acs

@Ksisterhen updated workflow attached

summarize_031023.yxmd

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?

binu_acs

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

Ksisterhen

nvm

binu_acs

@Ksisterhen can you upload your excel input file?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335