10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. Shell Programming and Scripting
Hi
My Input is like below
DELETE|MPI|AUD_UPD_AGENT|MPISYS
INSERT|MPI|AUD_UPD_AGENT|MPISYS
SELECT|MPI|AUD_UPD_AGENT|MPISYS
UPDATE|MPI|AUD_UPD_AGENT|MPISYS
DELETE|MPI|BDYMOD|MPISYS
INSERT|MPI|BDYMOD|MPISYS
SELECT|MPI|BDYMOD|MPISYS
UPDATE|MPI|BDYMOD|MPISYS
DELETE|MPI|BDYMOD_DESC|MPISYS... (4 Replies)
Discussion started by: dineshaila
4 Replies
5. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: morbid_angel
5 Replies
6. 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
7. 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
8. 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
9. 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
10. Shell Programming and Scripting
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... (4 Replies)
Discussion started by: mukhanj
4 Replies