0

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.

Clint
  • 93
  • 1
  • 2
  • 7

1 Answers1

0

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

SettingsForNormaliser

Results:

DesiredData

Clint
  • 93
  • 1
  • 2
  • 7