How do I make one id per column from multiple ids and group the ids together and create a new column for the associated

CloverDX Platform
1

For example:

I have one column with:
ID name
1 davies
1 davies
1 davies
2 king
2 king
2 king
2 king
3 thatcher
3 thatcher

It should be then:
1 davies 3
2 king 4
3 thatcher 3

Any help is appreciated.

Thanks.

2

Hi Mehmet,

There are multiple ways to accomplish this use case, I would recommend using the Denormalizer component. In our documentation you can see multiple examples that are similar to what you are trying to accomplish. You can also view examples on the Demoralizer in the Clover Designer itself.

Denormalizer Information