Sponsored Content
Top Forums Shell Programming and Scripting Aggregate data within the file Post 302961074 by venky338 on Monday 23rd of November 2015 04:22:05 PM
Old 11-23-2015
Aggregate data within the file

Guys,
I need to roll up data within the file and build a new file with the output and the same format as the original file.

The data should be rolled up for each unique combination of ord,line,date and hour.. The last column appr is always " "
Below is the format

Original File:

Code:
ord,line,Date,Hour,count,appr
1217,1,11/19/2015,"00",8,""
1217,1,11/19/2015,"00",24,""
1217,1,11/19/2015,"08",4,""
1217,1,11/19/2015,"09",20,""
1217,1,11/19/2015,"10",42,""
1217,1,11/19/2015,"10",62,""
 

New File:

Code:
ord,line,Date,Hour,count,appr
1217,1,11/19/2015,"00",32,""
1217,1,11/19/2015,"08",4,""
1217,1,11/19/2015,"09",20,""
1217,1,11/19/2015,"10",104,""

Any thoughts are appreciated

Last edited by jim mcnamara; 11-23-2015 at 06:04 PM..
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

aggregate ethernet ports under Solaris

I have been looking for info on how to aggregate 2 ore 3 NIC's into into one big pipe. Any advice would be appreciated. -Chuck (4 Replies)
Discussion started by: 98_1LE
4 Replies

2. UNIX for Dummies Questions & Answers

Aggregate values in a file & compare with sql output

Hi, I have a file containing the following data: junk123junk723itemcode001qty01price10total10junkjunk junk123junk723itemcode002qty02price10total20junkjunk .. .. .. could be 5000+ lines I have an algo and need a code to implement this: 1. Linecount = wc -l (should give 5000) 2. For i... (1 Reply)
Discussion started by: shiroh_1982
1 Replies

3. UNIX Desktop Questions & Answers

Aggregate title to an archive.log

Hello how are you, i have a question i have a file ale.log and i want to agregate a title and later a space when the text is over and put another title (when the text is over) how can i do this? thank you Example Last ------>(Title) i want to agregate pupu pupu pupu pupu... (1 Reply)
Discussion started by: enkei17
1 Replies

4. UNIX for Advanced & Expert Users

AWK aggregate records

Hy all, I have a problem...can some one help me... I have a file of records sort: 30|239|ORD|447702936929 |blackberry.net |20080728|141304|00000900|2|0000000000000536|28181|0000000006|0000000001|10|1 30|239|ORD|447702936929 |blackberry.net ... (4 Replies)
Discussion started by: anaconga
4 Replies

5. IP Networking

Aggregate two internet connections

Hi I have a question related to load balancing.I have two separate internet connections with 2Mbps speed and i would like to aggregate this two connections intro one connection with 4Mbps.Is it possible to do that, to put a Linux or Unix machine as a gateway?I read some stuff to split the... (3 Replies)
Discussion started by: tafil
3 Replies

6. Shell Programming and Scripting

Awk Multiple Files & Aggregate

file 1: 70|236|PPS|0501011818|mms|20090706|001452|00000024|2|0000000000000000|00000|0000000000|0000000000|40948000|1 70|236|PPS|0501020076|mms|20090705|204408|00000019|2|0000000000000000|00000|0000000000|0000000000|40947930|1... (3 Replies)
Discussion started by: magedfawzy
3 Replies

7. Shell Programming and Scripting

simple aggregate task

Hi experts, I need an help on the task below. INPUT: values separated by the tab,first row is the header 20110609 AS A 300.5000 20110609 AS R 200.5000 20110609 BR A 111.5000 20110609 BR R 222.5000 20110610 AS A 100.5500 20110610 AS ... (2 Replies)
Discussion started by: hernand
2 Replies

8. Shell Programming and Scripting

Aggregate variables bdfore ssh into remote host

Hi all, I have a problem where i'm trying to identify on which remote hosts the apps are running, ssh into it and restart them. In case more than 1 apps is running on same remote host, i want to be able to group it and ssh only once. E.g: app1 = 1.1.1.1 app2 = 1.1.1.2 app3 =... (4 Replies)
Discussion started by: varu0612
4 Replies

9. Solaris

IPMP over aggregate in Solaris 11

hi all, i start with solaris 11 and i am disapointed by the change on ip managing. i want to set a ipmp over tow aggregate but i dont find any doc and i am lost with the new commande switch1 net0 aggregate1 | net1 aggregate1 |-----| |... (1 Reply)
Discussion started by: sylvain
1 Replies
TRACEROUTE(1)                                                      User Commands                                                     TRACEROUTE(1)

NAME
traceroute - Trace the route to a host SYNOPSIS
traceroute [OPTION...] HOST DESCRIPTION
Print the route packets trace to network host. -f, --first-hop=NUM Set initial hop distance, that is the time-to-live. -g, --gateways=GATES List of gateways for loose source routing. -I, --icmp Use ICMP ECHO as probe. -m, --max-hop=NUM Set maximal hop count (default is 64). -M, --type=METHOD Use METHOD (icmp or udp) for traceroute operations, defaulting to udp. -p, --port=PORT Use destination PORT port (default is 33434). -q, --tries=NUM Send NUM probe packets per hop (default is 3). --resolve-hostnames Resolve hostnames. -t, --tos=NUM Set type of service (TOS) to NUM. -w, --wait=NUM Wait NUM seconds for response (default is 3). -?, --help Give this help list. --usage Give a short usage message. -V, --version Print program version. GNU inetutils 2015-05-15 TRACEROUTE(1)
All times are GMT -4. The time now is 07:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy