Answers to Frequently Asked Questions

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

Location_id| Picking_Limit    
------- | ---------------- :
2000| 120
2001|  170
2002| 150
2003| 100

IFS=","
while read f1 f2
do
awk -F, '{ A[$1]+=$2 } END { OFS=","; for (x in A) print x,A[x]; }'

IFS=","
while read f1 f2
do
awk -F, '{ A[$1]+=$2 } END { OFS=","; for (x in A) print x,A[x]; }' > /home/ec2-user/slotslatest.csv
done < Storewiseslots.csv