Merge duplicate row

Hey guys, just wondering if I want to convert a data table from,
cat 22234 sasdadasd
cat 3323223 sdasadasdasasdsa
dog sdsadasd asldkams

to:
cat 22234, 3323223 sasdadasd, sdasadasdasasdsa
dog sdsadasd asldkams
how would I go about doing it?

Hi @yas6191,

From what I understand, in the first column you have a key, and then you want all values for that key.
A data table is not the best choice for what you want to have.

I would use a Dictionary<String, List<.String>>. They dictionary key is the value from first column, “cat” or “dog”, and the dictionary value is a List with all values.

Regards
Silviu

1 Like

Hi Silviu,

Is it possible you can share an example workflow

Thanks

Hi @yas6191,

Here you have an example:
TableToDictionaryExample.xaml (15.7 KB)

Regards
Silviu