Write multiple row values in one row

CloverDX Platform
1

Hey guys,

i don’t know if it possible with cloverETL, but i need to control the writer job sequence for iterating values.
I need to write multiple row values from the source table in one single row in the target table.

my source table looks like:

ID | PropertiesID | PropertyValue
Peter |property 1 | big
Peter |property 2| small
Alex |property 3 | …
…|
…|

I want to produce a target table which will look like:

ID | Property 1 | Property 2 …
Peter | big | small

I don’t manage to create the target table and have no idea how to solve this problem with etl clover.

Does anybody have an idea?

Best Regards

2

Hi peterpan,

You can use component Denormalizer , which allows you to join multiple records into one. Please note it is available only in commercial Designer, not community version.

I hope this helps.