Pivot using awk Post: 302906519

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

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

3. Shell Programming and Scripting

Pivot script

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

4. UNIX for Dummies Questions & Answers

Pivot multiple

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

5. Shell Programming and Scripting

Pivot Column using awk

Hello everyone I have a 20M file which is having the below sample layout 1111,ABC,100 1111,DEF,200 1111,XYZ,300 4444,LMN,100 4444,AKH,500 4444,WCD,400 2222,ABC,100 7777,DEF,300 7777,WCD,300 I need to covert this to below format Output Party_ID|ABC|AKH|DEF|LMN|WCD|XYZ...

6. Shell Programming and Scripting

Pivot data using awk

7. UNIX for Beginners Questions & Answers

Data Pivot

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

8. Shell Programming and Scripting

Awk- Pivot Table Averages

Hi everyone, Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages. For example, suppose you have the following table with various individuals and their scores in round1 and round2: SAMPLE SCORE1 SCORE2 British ...

9. Programming

DB Query for Pivot

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

10. Shell Programming and Scripting

Pivot example

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

LEARN ABOUT CENTOS

rescan-scsi-bus.sh

RESCAN-SCSI-BUS.SH(1)						   User Commands					     RESCAN-SCSI-BUS.SH(1)

NAME

       rescan-scsi-bus.sh - script for adding and removing SCSI devices without rebooting

SYNOPSIS

       rescan-scsi-bus.sh [options] [host [host ...]]

OPTIONS

       -a, --alltargets
	      scan all targets, not just currently existing [default: disabled]

       -d     enable debug			 [default: 0]

       -l     activates scanning for LUNs 0--7	 [default: 0]

       -L NUM activates scanning for LUNs 0--NUM [default: 0]

       -w, --wide
	      scan for target device IDs 0--15	 [default: 0--7]

       -c     enables scanning of channels 0 1	 [default: 0 / all detected ones]

       -r, --remove
	      enables removing of devices	 [default: disabled]

       -f, --flush
	      flush failed multipath devices	 [default: disabled]

       -i, --issue-lip
	      issue a FibreChannel LIP reset	 [default: disabled]

       -u, --update
	      look for existing disks that have been remapped

       -s, --resize
	      look for resized disks and reload associated multipath devices, if applicable

       --forcerescan
	      rescan existing devices

       --forceremove
	      remove and readd every device (DANGEROUS)

       --nooptscan
	      don't stop looking for LUNs is 0 is not found

       --color
	      use coloured prefixes OLD/NEW/DEL

       --hosts=LIST
	      scan only host(s) in LIST

       --channels=LIST
	      scan only channel(s) in LIST

       --ids=LIST
	      scan only target ID(s) in LIST

       --luns=LIST
	      scan only lun(s) in LIST

       --sync, --nosync
	      issue a sync / no sync [default: sync if remove]

       --attachpq3
	      tell kernel to attach sg to LUN 0 that reports PQ=3

       --reportlun2
	      tell kernel to try REPORT_LUN even on SCSI2 devices

       --largelun
	      tell kernel to support LUNs > 7 even on SCSI2 devs

       --sparselun
	      tell kernel to support sparse LUN numbering

	      Host numbers may thus be specified either directly on cmd line (deprecated) or or with the --hosts=LIST parameter (recommended).

       LIST: A[-B][,C[-D]]... is a comma separated list of single values and ranges (No spaces allowed.)

SEE ALSO

       rescan-scsi-bus.sh Homepage: http://www.garloff.de/kurt/linux/#rescan-scsi

       sg3_utils Homepage: http://sg.danny.cz/sg

rescan-scsi-bus.sh 1.57 					    leden 2014						     RESCAN-SCSI-BUS.SH(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

Discussion started by: mukhanj

2. Shell Programming and Scripting

Pivot table

Discussion started by: gio001