The input file consists of
- 5 columns named Id, name, hours, additional hours(10%), additional hours (20%)
- if the values in the column - hours is other than 0, then in the output file under a column- type → enter - regular and scale must be → 100
- if the value in the column – additional hours (10%) is other then 0, then in the output file under column- type → enter - extra and scale must be → 10
- if the value in the column – additional hours (20%) is other then 0, then in the output file under column- type → enter - extra and scale must be → 20
The output file has 5 columns named
- id
- name
- hours
- type
- scale
I’ll be attaching the images of both the csv files
- input file
- output file