0

I am trying to use Spoon (Pentaho Data Integration) to change data that is in typical row format to Entity Attribute Value format.

My source data is as follows:

enter image description here

My Normaliser is setup as follows:

enter image description here

And here are the results:

enter image description here

Why is the value for the CONDITION_START_DATE and CONDITION_STOP_DATE in the string_value column instead of the date_value column?

According to this documentation

  • Fieldname: Name of the fields to normalize
  • Type: Give a string to classify the field.
  • New field: You can give one or more fields where the new value should transferred to.
jzacharuk
  • 2,058
  • 1
  • 16
  • 22

1 Answers1

0

Please check Normalizing multiple rows in a single step section in http://wiki.pentaho.com/display/EAI/Row+Normaliser. Accordind to this, you should have a group of fields with the same Type (pr_sl -> Product1, pr1_nr -> Product1), only in this case you can get multiple fields in output (pr_sl -> Product Sales, pr1_nr -> Product Number).

In your case you can convert dates to strings and then use row normalizer with single new field and then use formula for example:

enter image description here

And then convert date_value to date.

Rudolf Yurgenson
  • 603
  • 6
  • 12