Pivot component example

bongki.jeong

• June 12, 2014 00:00

• Answered

Follow

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.

• 

  slechtaj

  • June 12, 2014 13:09

  0

  Comment actions Permalink

  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.

  • PivotExample.grf
• 

  bongki.jeong

  • June 16, 2014 02:32

  0

  Comment actions Permalink

  Dear CloverETL,
  
  Thank you for your guide and help,
  
  It really helps me,
  
  I really appreciate again and agian,
  
  Best Regards,
  
  Bongki.

Please sign in to leave a comment.