08-04-2006
pivot
I have a sql table with :
Acitvity Date Value
ABC 7/11 10
DEF 7/11 98
ABC 7/12 23
DEF 7/12 100
SER 7/12 67
GRH 7/13 123
HJY 7/14 12
I want it to be reported in the following format:
Activity 7/11 7/12 7/13 7/14
ABC 10 23
DEF 98 100
SER 67
GRH 123
HJY 12
How do I do that? Please help. Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25
they represent the day the hour and the... (2 Replies)
Discussion started by: gio001
2 Replies
2. Shell Programming and Scripting
Hi All,
I am trying to pivot the contents in a file.
Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A
B
C
... (3 Replies)
Discussion started by: new_ds_man
3 Replies
3. Shell Programming and Scripting
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 Replies)
Discussion started by: boston_nilesh
3 Replies
4. Shell Programming and Scripting
Hi
Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file 1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb
1|c9|jjj
1|c10|kkk
1|c11|fffg
1|c12|nnn;indi;pak;linf;wer
1|c13|lllnk;li;sdfsd;oiuo
1|c14|ppp... (5 Replies)
Discussion started by: mabarif16
5 Replies
5. Shell Programming and Scripting
Hi All ,
I have a file as below .
A "1"
B "2"
C "3"
D "4"
E "5"
F "6"
A "11"
B "21"
C "31"
D "41"
E "51"
F "61"
And the output should be like
A B C D E F
1 2 3 4 5 6
11 21 31 41 51 (8 Replies)
Discussion started by: saj
8 Replies
6. UNIX for Dummies Questions & Answers
Dear friend,
I want to sum popul based on ville and reg.
input
date country ville reg popul
20131101 INDIA Gujarat College 322047286
20131101 USA Oregon 2 Kindergaten 477305599
20131101 INDIA Delhi 1 Ecole 255029428
20131101 MEXICO ... (2 Replies)
Discussion started by: radius
2 Replies
7. Shell Programming and Scripting
Hi,
I am writing a code to basically pivot the data.
awk -v var1="" -v var2="" -v var3="" -v var4="" -v var5="" -v Disp=0\
'BEGIN {FS=":"; OFS="|";}\
/^Pattern1/ {var1=$2;Disp=0;} \
/^Pattern2/ {var2=$2;} \
/^Pattern3/ {var3=$2;} \
/^Pattern4/ {var4=$2;} \
/^Pattern5/... (5 Replies)
Discussion started by: tostay2003
5 Replies
8. UNIX for Beginners Questions & Answers
Good Day,
I have file input
6285296582710|20170509|INDOTEL
6285296835209|20170509|INDOTEL
6285296940311|20170509|INDOTEL
6285297027737|20170509|MULTIFLAG
6285297027737|20170509|DELTA
6285297304373|20170510|INDOTEL
6285297384129|20170510|INDOTEL
6285296940311|20170510|MULTIFLAG... (2 Replies)
Discussion started by: radius
2 Replies
9. Programming
hi team
With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values .
A B STATUS
Insert Update Old
Insert Update New
Insert Update Final
Can someone guide how to... (2 Replies)
Discussion started by: Perlbaby
2 Replies
10. Shell Programming and Scripting
Hi all, I am new to shell scripting so pardon me for the questions I will be asking.
I was given a task where I have to pivot my data
Example
Source
SGPAPCTUMACCHEA
Expected output
SGP APC TUM
SGP APC ACC
SGP APC HEA
Can anybody assist me on this?Please use CODE tags as required... (3 Replies)
Discussion started by: redaela
3 Replies
LEARN ABOUT CENTOS
umad_set_grh_net
UMAD_SET_GRH_NET(3) OpenIB Programmer's Manual UMAD_SET_GRH_NET(3)
NAME
umad_set_grh_net - set GRH fields within umad buffer using network ordering
SYNOPSIS
#include <infiniband/umad.h>
int umad_set_grh_net(void *umad, void *mad_addr);
DESCRIPTION
umad_set_grh_net() sets the GRH fields (grh_present, gid, hop_limit, traffic_class, flow_label) within the specified umad buffer based on
the mad_addr supplied. The provided mad_addr fields are expected to be in network order. If the mad_addr pointer supplied is NULL, no GRH
is set. The argument mad_addr is a pointer to an ib_mad_addr_t struct, as specified in <infiniband/umad.h>. The argument umad is a
pointer to an ib_user_mad_t struct, as specified in <infiniband/umad.h>.
typedef struct ib_mad_addr {
uint32_t qpn;
uint32_t qkey;
uint16_t lid;
uint8_t sl;
uint8_t path_bits;
uint8_t grh_present;
uint8_t gid_index;
uint8_t hop_limit;
uint8_t traffic_class;
uint8_t gid[16];
uint32_t flow_label;
} ib_mad_addr_t;
typedef struct ib_user_mad {
uint32_t agent_id;
uint32_t status;
uint32_t timeout_ms;
uint32_t retries;
uint32_t length;
ib_mad_addr_t addr;
uint8_t data[0];
} ib_user_mad_t;
RETURN VALUE
umad_set_grh_net() returns 0 on success, and a negative value on errors. Currently, there are no errors indicated.
KNOWN BUGS
Not implemented.
SEE ALSO
umad_set_grh(3)
AUTHOR
Hal Rosenstock <halr@voltaire.com>
OpenIB May 24, 2007 UMAD_SET_GRH_NET(3)