CloverETL is now CloverDX - Learn Why

Mehmet
Posts: 1
Joined: Thu Jan 10, 2019 3:19 pm

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

Postby Mehmet » Thu Jan 10, 2019 3:33 pm

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.

vazquezrosariop
Posts: 150
Joined: Mon Feb 29, 2016 5:33 pm

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

Postby vazquezrosariop » Fri Jan 11, 2019 5:06 pm

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
---
Pedro X. Vazquez Rosario
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron