# Write multiple row values in one row

**URL:** <https://forum.cloverdx.com/t/write-multiple-row-values-in-one-row/1528>\
**Category:** CloverDX Platform\
**Created:** [November 20, 2014, 12:00am UTC](https://forum.cloverdx.com/t/write-multiple-row-values-in-one-row/1528 "2014-11-20T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![peterpan](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@peterpan](https://forum.cloverdx.com/u/peterpan)\
**Post date:** [November 20, 2014, 12:00am UTC](https://forum.cloverdx.com/t/write-multiple-row-values-in-one-row/1528/1 "2014-11-20T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\
**Post date:** [November 21, 2014, 9:17am UTC](https://forum.cloverdx.com/t/write-multiple-row-values-in-one-row/1528/2 "2014-11-21T09:17:39Z")

</div>

Hi peterpan,

You can use component [Denormalizer](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/denormalizer.html) , 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.