Pivots using ETL Metadata Injection

1
votes

It's quite simple to use row denormaliser to achieve pivots when we have few records which can be written manually in denorm step,but what when there's hundreds of thousands of records? I tried using etl metadata injection step, but I was unable to achieve my desired output.

Here is the link to my previous post where my source data has been defined.

and here is what I have tried enter image description here

row denormaliser options enter image description here

pivot_inject_etl_metadata.ktr enter image description here

enter image description here

enter image description here

1
pivotpivot-tablepentahokettlepdi

1 Answers

1
votes

Try something like this:

pivot_inject_etl_metadata.ktr:

Screenshot of etl_metadata

Group by: sku_id

Add constants:

Screenshot of Add constants

ETL Metadata Injection:

Screenshot of ETL Metadata Injection