Search code examples
pentaho-spoonpentaho-data-integration

Output row for each input in a column Pentaho Data Integration Spoon


I am new to Pentaho Data Integration, and I am looking to take the below column data and have an output for each entry in the date columns. Not sure how this can be done in spoon.

I have looked into the Denormalisation step, but examples are not very good that I have found. Also, I am not sure it would get me an output for each column value.


Starting Data:
StartingData

Desired Data:
DesiredData

Pentaho Forum version with sample files attached.


Solution

  • For this I found out you need to use the normaliser step with the below settings.

    SettingsForNormaliser

    Results:

    DesiredData