Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sum based on certain column
Top Forums UNIX for Dummies Questions & Answers Sum based on certain column Post 302834639 by rbatte1 on Friday 19th of July 2013 12:17:48 PM
Old 07-19-2013
Sum column 2? That is an alphabetic character.

It looks like you want to do something like the SQL code:-
Code:
select Col1, Col6, sum(Col4)
from table_name
group by Col1,Col6
order by Col1,Col6 ;

Is this right?

There could be many ways of writing variations in shell, C, awk etc. What is your source from and what are you hoping to run it in?



Robin
Liverpool/Blackburn

---------- Post updated at 05:17 PM ---------- Previous update was at 05:15 PM ----------

Ah, an edit, now my message doesn't make sense.

So, the equivalent of:-
Code:
select Col1, Col6, sum(Col3)
from table_name
group by Col1,Col6
order by Col1,Col6 ;


So, can you confirm?



Robin
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I sum one column based on another column?

Hi, I am new to this forum and new to awk. I have a file that contains 2 columns. Heres an example of what it looks like: 10 + 20 + 40 + 50 - 70 - So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1... (1 Reply)
Discussion started by: phil_heath
1 Replies

2. Shell Programming and Scripting

sum multiple columns based on column value

i have a file - it will be in sorted order on column 1 abc 0 1 abc 2 3 abc 3 5 def 1 7 def 0 1 -------- i'd like (awk maybe?) to get the results (any ideas)??? abc 5 9 def 1 8 (2 Replies)
Discussion started by: jjoe
2 Replies

3. Shell Programming and Scripting

Sum a column value based on multiple keys

Hi, I have below as i/p file: 5ABC 36488989 K 000010000ASB BYTRES 5PQR 45757754 K 000200005KPC HGTRET 5ABC 36488989 K 000045000ASB HGTRET 5GTH 36488989 K 000200200ASB BYTRES 5FTU ... (2 Replies)
Discussion started by: nirnkv
2 Replies

4. Shell Programming and Scripting

Sum Of Column Based On Column Condition

I have a following inputfile MT,AP,CDM,TTML,MUM,GS,SUCC,3 MT,AP,CDM,TTSL,AP,GS,FAIL,9 MT,AP,CDM,RCom,MAH,GS,SUCC,3 MT,AP,CDM,RTL,HP,GS,SUCC,1 MT,AP,CDM,Uni,UPE,GS,SUCC,2 MT,AP,CDM,Uni,MUM,GS,SUCC,2 TTSL,AP,GS,MT,MAH,CDM,SUCC,20 TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
Discussion started by: siramitsharma
2 Replies

5. UNIX for Dummies Questions & Answers

Sum based on column 1

i have file input aaa ccc,45567,rterw,1 bbb dcs,564543,hjghgh,1 aaa ccc,454,rterw,6 i want to sum based on column 1 expected output aaa ccc,7 bbb dcs,1 (4 Replies)
Discussion started by: radius
4 Replies

6. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies

7. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies

8. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies

9. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies

10. UNIX for Beginners Questions & Answers

Sum in file based column

Hi All, I have a file as below and want to sum based on the id in the first column Input 10264;ATE; 12 10265;SES;11 10266AUT;50 10264;ATE;10 10265;SES;13 10266AUT;89 10264;ATE;1 10265;SES;15 10266AUT;78 Output 10264;ATE; 23 10265;SES;39 10266AUT;139 (6 Replies)
Discussion started by: arunkumar_mca
6 Replies

LEARN ABOUT PHP

sybase_result

SYBASE_RESULT(3)														  SYBASE_RESULT(3)

sybase_result - Get result data

SYNOPSIS

       string sybase_result (resource  $result, int  $row, mixed  $field)

DESCRIPTION

	Returns the contents of the cell at the row and offset in the specified Sybase result set.

	When  working  on  large  result sets, you should consider using one of the functions that fetch an entire row (specified below). As these
       functions return the contents of multiple cells in one function call, they're MUCH quicker than sybase_result(). Also, note that specifying
       a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument.

	Recommended high-performance alternatives: sybase_fetch_row(3), sybase_fetch_array(3) and sybase_fetch_object(3).

PARAMETERS

	      o $result
		-

	      o $row
		-

	      o $field
		-  The field argument can be the field's offset, or the field's name, or the field's table dot field's name (tablename.fieldname).
		If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column name.

RETURN VALUES

       sybase_result(3) returns the contents of one cell from a Sybase result set.

PHP Documentation Group 													  SYBASE_RESULT(3)
All times are GMT -4. The time now is 09:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy