UNIX command to pivot data Post: 302991170

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. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script

3. UNIX for Dummies Questions & Answers

Validating XSL sheet data in Unix Data file

Dear All, Need your help. In my day to day activities I have to validate/search Excel Sheet data (eg.say Application No. 0066782345) data into the Unix environment file whether the same data is present in that file or not. There are hundreds of records coming in excel file and I am doing grep...

4. UNIX for Dummies Questions & Answers

TWO QUESTIONS...How to create your own command in UNIX server,How to enter data in a file by script

I am a quite newbie on UNIX SCRIPTING...Please help me solving this two questions... 1st Question; I want to create one command that will run a script when anyone use that command on that server... I mean, in the prompt if I put my name 'Rony' it will execute a script called 'rony.sh'. How can...

5. UNIX for Advanced & Expert Users

Checking missing data's sequence (shell script | UNIX command)

Dear All members, i have some trouble here, i want to ask your help. The case is: I have some data, it's like: -ABCD1234 -ABCD1235 -ABCD1237 -BCDE1111 -BCDE1112 -BCDE1114 there is some missing data's sequence (the format is: ABCD = name 1234 = sequence). I want to print the...

6. Shell Programming and Scripting

Pivot using awk

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

7. Shell Programming and Scripting

Compare output of UNIX command and match data to text file

I am working on an outage script and I run a command from the command line which tells me the amount of generator failures in my market. The output of this command only gives me three digits to identify the site by. I have a master list of all sites in a separate file, call it list.txt. If my...

8. Shell Programming and Scripting

Pivot data using awk

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

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 DEBIAN

plsdidev

PLSDIDEV(3plplot)						    PLplot API							 PLSDIDEV(3plplot)

NAME

       plsdidev - Set parameters that define current device-space window

SYNOPSIS

       plsdidev(mar, aspect, jx, jy)

DESCRIPTION

       Set  relative  margin width, aspect ratio, and relative justification that define current device-space window.  If you want to just use the
       previous value for any of these, just pass in the magic value PL_NOTSET. It is unlikely that one should ever  need  to  change  the  aspect
       ratio but it's in there for completeness. If plsdidev(3plplot) is not called the default values of mar, jx, and jy are all 0. aspect is set
       to a device-specific value.

       Redacted form: plsdidev(mar, aspect, jx, jy)

       This function is used in example 31.

ARGUMENTS

       mar (PLFLT, input)
	      Relative margin width.

       aspect (PLFLT, input)
	      Aspect ratio.

       jx (PLFLT, input)
	      Relative justification in x. Value must lie in the range -0.5 to 0.5.

       jy (PLFLT, input)
	      Relative justification in y. Value must lie in the range -0.5 to 0.5.

AUTHORS

       Geoffrey Furnish and Maurice LeBrun wrote and maintain PLplot.  This man page was automatically generated from the DocBook  source  of  the
       PLplot documentation, maintained by Alan W. Irwin and Rafael Laboissiere.

SEE ALSO

       PLplot documentation at http://plplot.sourceforge.net/resources.

								   August, 2012 						 PLSDIDEV(3plplot)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

Discussion started by: mukhanj

2. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

Discussion started by: Anne Grace

3. UNIX for Dummies Questions & Answers

Validating XSL sheet data in Unix Data file

Discussion started by: ravijunghare

4. UNIX for Dummies Questions & Answers

TWO QUESTIONS...How to create your own command in UNIX server,How to enter data in a file by script

Discussion started by: Rony-123