HI,
Can you guys please help me in creating Pivot table for below data using shell script?
Location_id| Effective_date| Picking_limit
------- | ---------------- | ----------:
2000| 04/04/2020| 120
2001| 04/04/2020| 130
2002| 04/04/2020 | 150
2003| 04/04/2020| 100
2001| 04/04/2020| 140
I want output as below
Location_id| Picking_Limit
------- | ---------------- :
2000| 120
2001| 170
2002| 150
2003| 100
Basically i prepared a pivot table for location id. Where ever location id is same i am adding value of picking limit and wanted to write in a new csv file.
Thanks,
Swetha. G