Search Results

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

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

HI,
Can you guys please help me in creating Pivot table for below data using shell script?

Location_id| Effective_date| Picking_limit
------- | ---------------- | ----------:
2000|...