Sponsored Content
Top Forums Shell Programming and Scripting Convert Column data values to rows Post 302937312 by Hypesslearner on Thursday 5th of March 2015 01:41:35 AM
Old 03-05-2015
Convert Column data values to rows

Hi all ,

I have a file with the below content


Code:
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep
 
Data section 
8243651u7|juanalk||emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|10|20|30|40|50|0|0|0|0|0|0|0

I need to convert this file as below
Code:
Header Section 
employee |employee name |Period|Job description |Job code |Unit code |Account |geography |C1 |C2 |C3|C4|C5|C6|C7|C8|C9|Csource |Data
 
 
Data section 
8243651u7|juanalk|Oct|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|10
8243651u7|juanalk|Nov|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|20
8243651u7|juanalk|Dec|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|30
8243651u7|juanalk|Jan|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|40
8243651u7|juanalk|Feb|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|50
8243651u7|juanalk|Mar|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Apr|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|May|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Jun|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Jul|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Aug|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Sep|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0


Basically all the 12 months data is coming in columns initially and I need to keep that data into rows now .

Can anyone help me how this can be done in unix fastly

thanks

Moderator's Comments:
Mod Comment Please use separate sets of code tags for separate code and data samples

Last edited by Scrutinizer; 03-05-2015 at 03:58 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert rows into column

if u have a data 2 4 6 8 5 4 4 5 6 then result shud be like 2 4 6 7 5 4 4 5 6 (3 Replies)
Discussion started by: cdfd123
3 Replies

2. Shell Programming and Scripting

Convert Column to rows

Hi, I have a file with below contents. Heading1 Heading2 Heading3 Heading4 Value1 Value2 Value3 Value4 The file has only 2 rows and is tab separated The desired output is : Heading1 Value1 Heading2 Value2 Heading3 Value3 Heading4 Value4 CAn you please help? (5 Replies)
Discussion started by: kaponeh
5 Replies

3. Shell Programming and Scripting

Convert rows into column groups

Hi I have the text file like this "A" "AA Info" "AA Text" "AAA" "ABC" "ABC Info" "ABC Tech" "AGH" "SYN" "SYMBony" "SYN BEREN" Like about 2000 lines Output would be in Column with groups like following "A" "AA Info", "AA Text" "AAA" "ABC","ABC Info","ABC Tech" (0 Replies)
Discussion started by: selvanraj
0 Replies

4. UNIX for Dummies Questions & Answers

Suggestion to convert data in rows to data in columns

Hello everyone! I have a huge dataset looking like this: nameX nameX 0 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ............... nameY nameY 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ..... nameB nameB 0 1 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ..... (can be several thousands of codes) and I need... (8 Replies)
Discussion started by: kush
8 Replies

5. Shell Programming and Scripting

Convert Column Values to a Range of Values

I have a list of columns with values that I need to transform into a row containing the range of each column. For example: "Column A" 1 2 3 4 10 12 14 15 16 17 18 "Column B" 1 4 5 6 (4 Replies)
Discussion started by: newbio
4 Replies

6. Shell Programming and Scripting

How to convert values in a line to rows?

hi, I am basically running a sql that returns me values and I have stored them to a variable for example value of the variable will be: 123 124 345 now I want to write values stored in the variable into a file as 123 124 345 thanks in advance (3 Replies)
Discussion started by: babom
3 Replies

7. Shell Programming and Scripting

Convert Rows into Column

Hi Experts, I have a requirement to convert rows into columns. For e.g. Input File: Output File should be like Appreciate if you could suggest code snippet(may be awk) for above requirement... Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies

8. Shell Programming and Scripting

Convert rows to column and add header

Hi, I need help to convert rows in input file into a table. inputfile 192.98.1 192.98.192.98.17 VVC family Zorro 10 192.98.1 192.98.192.98.17 VVC family Ace 1 192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Discussion started by: redse171
4 Replies

9. Shell Programming and Scripting

Convert rows into column along with header

Hi, I have a requirement to format the data in a new order. Here is my source format : ppp ***Wed Dec 16 10:32:30 GMT 2015 header1 header2 header3 header4 header5 server1 0.00 0.02 0.07 0.98 server2 0.01 0.00 0.08 0.79 server3 0.05 0.82 0.77 0.86 ... (18 Replies)
Discussion started by: john_prince
18 Replies

10. Programming

DB2 Query -Convert multi values from column to rows

Hi Team I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows . For example : Column 1 Column2 Jan,Feb Hold,Sell,Buy Expected Result Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies
GRAM Job States(3)					       globus gram protocol						GRAM Job States(3)

NAME
GRAM Job States - Enumerations enum globus_gram_protocol_job_state_t { GLOBUS_GRAM_PROTOCOL_JOB_STATE_PENDING = 1, GLOBUS_GRAM_PROTOCOL_JOB_STATE_ACTIVE = 2, GLOBUS_GRAM_PROTOCOL_JOB_STATE_FAILED = 4, GLOBUS_GRAM_PROTOCOL_JOB_STATE_DONE = 8, GLOBUS_GRAM_PROTOCOL_JOB_STATE_SUSPENDED = 16, GLOBUS_GRAM_PROTOCOL_JOB_STATE_UNSUBMITTED = 32, GLOBUS_GRAM_PROTOCOL_JOB_STATE_STAGE_IN = 64, GLOBUS_GRAM_PROTOCOL_JOB_STATE_STAGE_OUT = 128, GLOBUS_GRAM_PROTOCOL_JOB_STATE_ALL = 0xFFFFF } Detailed Description The globus_gram_protocol_job_state_t contains information about the current state of the job as known by the job manager. Job state changes are sent by the Job Manager to all registered clients. A client may ask for information from the job manager via the status request. Enumeration Type Documentation enum globus_gram_protocol_job_state_t GRAM Job States. Enumerator: GLOBUS_GRAM_PROTOCOL_JOB_STATE_PENDING The job is waiting for resources to become available to run. GLOBUS_GRAM_PROTOCOL_JOB_STATE_ACTIVE The job has received resources and the application is executing. GLOBUS_GRAM_PROTOCOL_JOB_STATE_FAILED The job terminated before completion because an error, user-triggered cancel, or system-triggered cancel. GLOBUS_GRAM_PROTOCOL_JOB_STATE_DONE The job completed successfully. GLOBUS_GRAM_PROTOCOL_JOB_STATE_SUSPENDED The job has been suspended. Resources which were allocated for this job may have been released due to some scheduler-specific reason. GLOBUS_GRAM_PROTOCOL_JOB_STATE_UNSUBMITTED The job has not been submitted to the scheduler yet, pending the reception of the GLOBUS_GRAM_PROTOCOL_JOB_SIGNAL_COMMIT_REQUEST signal from a client. GLOBUS_GRAM_PROTOCOL_JOB_STATE_STAGE_IN The job manager is staging in files to run the job. GLOBUS_GRAM_PROTOCOL_JOB_STATE_STAGE_OUT The job manager is staging out files generated by the job. GLOBUS_GRAM_PROTOCOL_JOB_STATE_ALL A mask of all job states. Author Generated automatically by Doxygen for globus gram protocol from the source code. Version 11.3 Mon Apr 30 2012 GRAM Job States(3)
All times are GMT -4. The time now is 03:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy