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

csv1:

StoreID Emailcount

2000 3

2001 2


csv2:

StoreID Slotcount

2000 100

2001 120

Output required as below
StoreID ...

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|...