Hi Friends,
I need to pivot data .
Below is my source data
Source Data
===================================
I need output like below
===================
For each 100 percent PRTY_KEY_ID for same PK, I need to list down its all 90 and 80's PRTY_KEY_ID
So for PK = 007824822, FOR first 100 % PRTY_KEY_ID (428844791), I will need four rows(3 FOR 80 and 1 for 90)
for PK =007824822, , For next 100% PRTY_KEY_ID (429840574),I will need four rows(3 FOR 80 and 1 for 90)
Thne next PK and so on
===============
Need your help
Thanks in advance.
Moderator's Comments:
Please use CODE tags when displaying sample input, sample output, and code segments as required by forum rules.
Last edited by Don Cragun; 04-27-2016 at 06:30 AM..
Reason: Add CODE tags.
Original file we are getting .......
Item Period Amt
P1 106 1000
P1 206 1500
P1 106 2000
P2 256 5800
P2 650 7500
My output should be like this
Item 106 206 256 650 ............
P1 1000 1500 0 ... (1 Reply)
Hi,
I need help on how to pivot the data in UNIX. I have one input file in which The facts(FACT1,FACT2..) and PERIOD(JAN,FEB..) are columns.I need to pivot the data. For Exampe The input file and output file looks like below. Could you please help with this using awk:).
INPUT:
====== ... (1 Reply)
Hello Unix guys,
I have the following 4 column data, which is a output of db2 select query:
Need to pivot the data.
sample Input:
Year Month Country Counts
2012 Aug Canada 114
2012 Aug USA 92
2012 Aug Mexico 3
2012 Aug ... (3 Replies)
Hi ,
Please any one help using shell scripts achieve the below output(pivoting on top_cd i mean type code values will come as individual columns and fixed amount is value for that .Any help would be greate
tx_id tx_amt typ_cd fixed_dis_amt
100 200 mc ... (3 Replies)
I/P:
I/P:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
O/P:
a b c
2017/01/01 10 20 40
2017/02/01 10 20 30 (18 Replies)
Hi Team,
Could you please help me with the below scenario.
I have a file which is in the below format.
Zipcode,001,001f,002,002f,003,003f,004,004f,005,005f,006,006f,007,007f
0050, ,0, ,0, ,0, ,1,*,7, ,7, ,7
0060, ,0, ,0, ,7, ,0,*,7, ,0, ,0
Would need the output as below.
First field... (1 Reply)
Discussion started by: saj
1 Replies
LEARN ABOUT DEBIAN
perlio::via::symlink
symlink(3pm) User Contributed Perl Documentation symlink(3pm)NAME
PerlIO::via::symlink - PerlIO layers for create symlinks
SYNOPSIS
open $fh, '>:via(symlink)', $fname;
print $fh "link foobar";
close $fh;
DESCRIPTION
The PerlIO layer "symlink" allows you to create a symbolic link by writing to the file handle.
You need to write C"link $name" to the file handle. If the format does not match, "close" will fail with EINVAL.
TEST COVERAGE ----------------------------------- ------ ------ ------ ------ ------ ------
File stmt branch cond sub time total
----------------------------------- ------ ------ ------ ------ ------ ------
blib/lib/PerlIO/via/symlink.pm 100.0 100.0 n/a 100.0 100.0 100.0
Total 100.0 100.0 n/a 100.0 100.0 100.0
----------------------------------- ------ ------ ------ ------ ------ ------
AUTHORS
Chia-liang Kao <clkao@clkao.org>
COPYRIGHT
Copyright 2004-2005 by Chia-liang Kao <clkao@clkao.org>.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See <http://www.perl.com/perl/misc/Artistic.html>
perl v5.8.8 2005-04-21 symlink(3pm)