Load script - if then

[Luka-enterprise]

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