Write multiple row values in one row

peterpan

• November 20, 2014 00:00

• Answered

Follow

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

• 

  admin

  • November 21, 2014 09:17

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.