Shell Programming and Scripting

OK,
could you give an example of the output that you want?

<b>I would like my output to be similar to the one below:</b>

LOGIN_ID ACTION_CODE DATE CASE_REFERENCE FRAUD_TYPE_ID ESTIMATE_LOSS
james_j Assign 19/03/2008 832090883 PD Summary alarm 29401.46
james_j Open 19/03/2008 838521885 High Aggregate Cost of Calls 112457.79
james_j Open 01/04/2008 838521885 High Aggregate Cost of Calls 112457.79
james_j Assign 07/04/2008 782078038 Very Long Duration Call 0.19
james_j Assign 07/04/2008 734646922 Very Long Duration Call 4
james_j Assign 07/04/2008 730799413 Very Long Duration Call 50.13
james_j Assign 07/04/2008 833063410 Very Long Duration Call 4261.97
james_j Open 07/04/2008 832090883 PD Summary alarm 29401.46
james_j Open 07/04/2008 838521885 High Aggregate Cost of Calls 112457.79
james_j Open 08/04/2008 782078038 Very Long Duration Call 0.19
james_j Open 08/04/2008 734646922 Very Long Duration Call 4
james_j Open 08/04/2008 832090883 PD Summary alarm 29401.46
james_j Open 08/04/2008 838521885 High Aggregate Cost of Calls 112457.79
james_j Open 09/04/2008 734646922 Very Long Duration Call 4
james_j Open 09/04/2008 730799413 Very Long Duration Call 50.13
james_j Open 09/04/2008 833063410 Very Long Duration Call 4261.97
james_j Open 09/04/2008 832090883 PD Summary alarm 29401.46
james_j Open 09/04/2008 838521885 High Aggregate Cost of Calls 112457.79
james_j Open 10/04/2008 782078038 Very Long Duration Call 0.19
james_j Open 10/04/2008 734646922 Very Long Duration Call 4
james_j Open 10/04/2008 730799413 Very Long Duration Call 50.13
james_j Open 10/04/2008 833063410 Very Long Duration Call 4261.97
james_j Open 11/04/2008 734646922 Very Long Duration Call 4
james_j Open 11/04/2008 832090883 PD Summary alarm 29401.46
james_j Open 17/04/2008 824115119 PD Summary alarm 118856.9
james_j Closed 17/04/2008 824115118 PD Summary alarm 118856.9

Total Loss for Open Tickets 807392.27
Total Loss for Closed Tickets 118856.9
Total Loss for Assigned Tickets 33717.75

OK,
reading your post it's not clear if one row = one line.
Try to attach a sample from your data (or use code tags).

If the above is not true, you should change the sql (if the client is sqlplus: adjust the colum format and the linesize).

Hi Radoulov,

I have decided to calculate the sum of the total_estimate_loss using sql.

Thnx for all your help.

Ta,

This should give the expected output:

Code:

awk ' NR>1{arr[$2]+=$NF}
END{for(i in arr){printf("Total lost for %s Tickets %10.2f\n", i, arr[i])}}' file

cat awkadvice.d | awk 'BEGIN {
Assign=0;
Open=1;
Closed=2;
sum[Assign]=0;
sum[Open]=0;
sum[Closed]=0;
}

{
print $0
if ($2 == "Assign" ) sum[Assign]=sum[Assign]+$NF;
if ($2 == "Open" ) sum[Open]=sum[Open]+$NF;
if ($2 == "Closed" ) sum[Closed]=sum[Closed]+$NF;
}

END {
print
print "Total estimated cost for Assign is " sum[Assign]
print "Total estimated cost for Open is " sum[Open]
print "Total estimated cost for Closed is " sum[Closed]

}'

aju_cup,

The OP decided to use sqlplus to do the job, but have you tried to get the desired output with your script?
I don't!?

Regards