Pivot component example

CloverDX Platform
1

Dear CloverETL,

I have a basic question, I am testing to use Pivot component.

But I got an error below,

ERROR [main] - Error during graph initialization !
Component [Pivot:PIVOT] initilization failed.
Normalizer initialization failed: Value for output field is not defined; define valueField or getOutputFieldValue function.

I read CloverETL manaual about that, but I could not find the error.

I think I would miss something, so is there any sample graph?

Manual document is not help to me, this is the just definition about the component.
http://doc.cloveretl.com/documentation/ … pivot.html

Is there any real example for the beginner?

Thank you very much,

Bongki.

2

Hi Bongki,

Please find attached example with pivot component.

In the component‘s dialog, there are two important attributes:

  • Field defining output field name
    Selected input field‘s value tells Clover the name of target output field name (into that field values from the next attribute will be mapped)

  • Field defining output field value
    Selected input field’s value will be mapped to the field name selected in the previous attribute.

I believe the example is pretty straightforward. See the difference between input and output data and check them against the values set in the component’s attributes.

Hope this helps.

3

Dear CloverETL,

Thank you for your guide and help,

It really helps me,

I really appreciate again and agian,

Best Regards,

Bongki.