Pentaho

 View Only

 Can I denormalize rows with the same ID to new colums?

  • Pentaho
  • Pentaho
  • Pentaho Data Integration PDI
arin gregoriades's profile image
arin gregoriades posted 09-08-2021 19:39

I'm getting data from JSON like this

The punchtype is either ID or OD. For each Punchdate there can be multiple ID and OD punchtimes. I need to have a table that has rows, eebadge, punchdate, ID_1, ID_2, Etc...

 

This is what I have but I'm getting errors. Any ideas?