2

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

Community
  • 1
  • 1
Deepesh
  • 820
  • 1
  • 14
  • 32

1 Answers1

1

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

bolav
  • 6,938
  • 2
  • 18
  • 42