apache / hop

Hop Orchestration Platform
https://hop.apache.org/
Apache License 2.0
983 stars 352 forks source link

[Feature Request]: Sample showing a practical application of Hop in Finance #3176

Open usbrandon opened 1 year ago

usbrandon commented 1 year ago

What would you like to happen?

Financial analysts frequently model their time periods and measures from left to right (using columns for each time period). It is often the case that pivoting these for various calculations and storing in a table is required. I wanted to contribute this self contained sample where you have several different measure types (Dates, Strings, Unit Quanities, and currency) rows that have to be thoughtfully handled. This should help with strange steps like the row normalizer.

financial_reporting_pivot.zip image

Issue Priority

Priority: 3

Issue Component

Component: Samples

mattcasters commented 1 year ago

I think it can be the basis for a great example. My experience with complex examples is that they need some hand-holding for the reader, to make sense of it all. Perhaps it would be possible to create a documentation page for it?