Hi everyone,
I got a table with:
Year | Month | Value | Department
I need load script that will do next:
If Department = "Accounting" load value from that line:
Year | Month | Value*0,25 | Department AS "Origin Department" | New department (new Department will need to be for Example "Sales")
I wanna create 4 loading script to get 100% of the value
I got a table in attach for folks that are good in ETL and like a nice challenge 🙂
Idea is to get LVL1 values and LVL 2 values on end Department
Thanks
