# Denormalizer

**URL:** <https://forum.cloverdx.com/t/denormalizer/1394>\
**Category:** CloverDX Platform\
**Created:** [April 22, 2014, 12:00am UTC](https://forum.cloverdx.com/t/denormalizer/1394 "2014-04-22T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ibala\_in](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@ibala\_in](https://forum.cloverdx.com/u/ibala_in)\
**Post date:** [April 22, 2014, 12:00am UTC](https://forum.cloverdx.com/t/denormalizer/1394/1 "2014-04-22T00:00:00Z")

</div>

Hi,

Need a help with denormalizer in clover etl.

I have the data below in the excel format,

Person Compliants Resolution  
Person1 Compliant1 Resolution1  
Person1 Compliant2 Resolution2  
Person1 Compliant3 Resolution3  
Person2 Compliant11 Resolution11  
Person2 Complaint22 Resolution22

I want this in the below format

Person Complaints Resolution  
Person1 Compliant1, Compliant2, Compliant3 Resolution1, Resolution2, Resolution3  
Person2 Compliant11, Compliant22 Resolution11, Resolution22

Would appreciate if someone can help with the clover etl.

Thanks,

---

<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:** [April 23, 2014, 12:50pm UTC](https://forum.cloverdx.com/t/denormalizer/1394/2 "2014-04-23T12:50:54Z")

</div>

Hi ibala\_in,

I would recommend you to use [http://doc.cloveretl.com/documentation/ … lizer.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/denormalizer.html) where you get access to all records of one person and let you accumulate those into single record - buffer, which will be output record. You have at least 2 possibilities of buffer format:

1. For Complaints and Resolutions use \*string\* type and concatenate values

2. For Complaints and Resolutions use \*string list\* ([http://doc.cloveretl.com/documentation/ … ields.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/multivalue-fields.html)) and just add values into it. However please note that just some components support lists for input/output. See link for details.

I hope it helps.