pentahokettlepentaho-data-integrationpdidata-integration

How to use Pentaho Denormalizer Step with Metadata Injection

I want to denormalize the below data. Input Input

Required output

col1   col2   col3   col4

aaa    bbb    ccc    ddd

I think in Pentaho we can use Metadata Injection step with Denormalizer step to dynamically denormalize all row values to columns

Solution

  • Yes, its possible. One constraint is you need to provide your input data twice. I have prepared a solution , you can see dynamic denormalize from Here