Date is retrieved from SQL it is in this format YYYY-MM-DD HH24MI i.e 2019-12-12 0001 and is having data for 1 hour i.e 2019-12-12 0001 to 2019-12-12 0060
the whole output of the query consists of 3 columns date_time calling_app and count of requests
SQL script output is like given below
Code:
Date_time Calling_app Count
2019-12-12 0000 X 12
2019-12-12 0001 y 3
2019-12-12 0002 c 4
2019-12-12 0003 v 6
2019-12-12 0004 a 8
2019-12-12 0005 q 7
Want output like this, Also please note that there can be entries in between the timestamps for other applications as well
Code:
Date_time x y c v a q
2019-12-12 0000 12
2019-12-12 0001 3
2019-12-12 0002 4
2019-12-12 0003 6
2019-12-12 0004 8
2019-12-12 0005 7
Also pleas let me know if any more inputs or data is required from my end.
Thanks,
TNT47
Moderator's Comments:
Please do wrap your samples/codes in your posts in CODE TAGS as per forum rules.
Last edited by RavinderSingh13; 12-16-2019 at 01:31 AM..
Hi,
I want to compare two files. Files will look like as follows:
file1:
ASDFGHJU|1234567890123456
QWERTYUI|3456789098900890
file2:
ZXCVBVNM|0987654321234567
POLKIJUYH|1234789060985478
output file should be:
ASDFGHJU|1234567890123456
QWERTYUI|3456789098900890
Thnaks in advance (6 Replies)
Hi all,
I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values.
Output something like
TypeA TypeB
TestCase1 Pass Fail
TestCase2 Pass ... (2 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi ,
This is my first thread ; facing some issues withmy sed script
I need to insert the code from my log file which is between two keywords.
content is like this ........
log
############################
log1 log2
231 "Ban" "tom" and the line one of the cross line
friend... (2 Replies)
Hi all,
I am beginner in UNIX...I want to use unix shell script to create text.file...I know how to use using by command...can anybody tell me for the script?
Thanks
i changed the threads title from "tex file" to "text file", because "tex" would probably be misunderstood as reference to... (4 Replies)
Hi ,
I am having two files like this
FILE1
####################
input SI_TESTONLY_R_00;
input CE0_SE_INPUT_TESTONLY;
input CE0_TCLK_TESTONLY;
input SI_JTGCLOCKDR_JTAG_R_00;
input CE0_TCLK_JTGCLOCKDR_JTAG;
input CE0_SE_INPUT_JTGCLOCKDR_JTAG;
output SO_TESTONLY_R_00;
output... (2 Replies)
Hi Team,
Could you please help me on below query:
I want to retrieve XML elements from one .xml file. This .xml file has commented tags as well. so i am planning to write Unix command/script which 1.will chekc for this .xml file
2. it will ignore the commented XML lines. i.e. XML tags between... (3 Replies)
Hi folks,
I am new for shell script, I hope somebody to help me to write shell script
My requirement is below steps
1. I have apache access.log i.e located in /var/log/httpd/
Ex.
127.0.0.1 - - "GET... (14 Replies)
I have a large semicolon delimited file with thousands of columns and many thousands of line. It looks like:
ID1;ID2;ID3;ID4;A_1;B_1;C_1;A_2;B_2;C_2;A_3;B_3;C_3
AA;ax;ay;az;01;02;03;04;05;06;07;08;09
BB;bx;by;bz;03;05;33;44;15;26;27;08;09
I want to split this table in to multiple files:
... (1 Reply)
Discussion started by: trymega
1 Replies
LEARN ABOUT OSX
taskpolicy
taskpolicy(8) BSD System Manager's Manual taskpolicy(8)NAME
taskpolicy -- execute a program with an altered I/O or scheduling policy
SYNOPSIS
taskpolicy [-d policy] [-b] program [arg1 [...]]
DESCRIPTION
The taskpolicy program uses the setiopolicy_np(3) and setpriority(2) APIs to execute a program with altered I/O or scheduling policies. All
children of the specified program also inherit these policies.
taskpolicy accepts the following flags and arguments:
-d policy Run the program after calling setiopolicy_np(3) with an iotype of IOPOL_TYPE_DISK, a scope of IOPOL_SCOPE_PROCESS, and the
specified policy. The argument can either be an integer, or a symbolic string like "default" or "throttle", which is inter-
preted case-insensitively.
-g policy Run the program after calling setiopolicy_np(3) with an iotype of IOPOL_TYPE_DISK, a scope of IOPOL_SCOPE_DARWIN_BG, and the
specified policy. The argument is interpreted in the same manor as -d.
-b Run the program after calling setpriority(2) with a priority of PRIO_DARWIN_BG.
SEE ALSO setpriority(2), setiopolicy_np(3)Darwin June 2, 2019 Darwin
12-16-2019
