Denormalizer

CloverDX Platform
1

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,

2

Hi ibala_in,

I would recommend you to use http://doc.cloveretl.com/documentation/ … lizer.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) 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.