Merge data from rows

Question

Hello,

I am having a hard time figuring out how to merge specific rows into one, while leaving the remaining rows as they are.

My table looks like this:

IDFieldValue123GameToyStory123AnimalDog123AnimalCat123AnimalHorse123FlowerTulip4567FlowerMargarida4567AnimalHorse4567AnimalTiger

And I want to turn it into:

IDFieldValue123GameToyStory123AnimalDog, Cat, Horse123FlowerTulip4567FlowerMargarida4567AnimalHorse, Tiger

Basically I want to merge only the rows in which the Field is Animal, and I want to concatenate the data using commas. While leaving all the other rows as they are. But I only want to merge those who belong to the same ID. Any ideas on how to proceed?

AngelosPachis · Answer

Hi @cutehappybear ,

You can filter out the records that contain "Animal" under the [Field] column and then feed that to a summarize tool, configured to group by ID and Field and concatenate the field [Value]. Then you can union that back to your dataset and you are good to go.

( If you want to maintain the sort order, then you can add a record ID before the filter tool and use that to grab the first record ID for each ID and animal type combo and use that after your union to sort on)

Hope that helps,

Angelos

sample_workflow.yxmd

binu_acs · Answer

@cutehappybear

summarize1.yxmd