7

Generate tabular data based on a column value from an existing data file

view full story
linux-howto

http://www.unix.com – Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I need to find the first occurring date and the last occurring date for a particular value in column 4 for each combination of column 2 and 3 For example the output from above data should be: 1,1,01/28/2012,01/29/2012,98955 1,1,01/30/2012,02/01/2012,98896 1,1,02/02/2012,99/99/9999,98899 1,2,0 (HowTos)

suki's picture
Submitted by suki on 01/18/2013 – Made popular on 01/18/2013

Stories similar to Generate tabular data based on a column value from an existing data file

Basics:I'm running SQL Server 2008 R2 Standard.

I need to create a query that has data from multiple columns (Columns 1-6 with coresponding Date started and Date Completed data) displayed vertically, but also has the column name the preeceeding column to identify it...along with other data (Record number, status).

Record Number, Status, Column Name, Date Started, DateCompleted 1, Open, Column 1,

Hi

my data is in csv-format ...

Code: ... 13/08/2012,16:30,303.30,5.10,3,2,2,1,9360.0,322 13/08/2012,16:40,305.50,5.00,3,2,2,1,12360.0,322 13/08/2012,16:50,319.90,3.80,3,2,1,0,2280.0 13/08/2012,17:00,326.10,3.50,3,2,1,1,4380.0,321 13/08/2012,17:10,333.00,3.80,3,3,1,0,2280.0 13/08/2012,17:20,330.20,4.50,3,3,2,0,2700.0 13/08/2012,17:30,332.00,4.20,3,3,2,1,5220.0,332 13/08/2012,17:40,334.90,3.

Hi,

I've one requirement. I have to split one comma delimited file into multiple files based on one of the column values.

How can I achieve this Unix

Here is the sample data.

Code: 12-11-2012,PNL,158406 12-11-2012,RISK,4564 12-11-2012,VAR_1D,310101 12-11-2012,VAR_10D,310101 12-11-2012,CB,866 12-11-2012,STR_VAR_1D,298494 12-11-2012,STR_VAR_10D,309623 09-11-2012,PNL,1024106 09-11-2012,RISK,4565 09-11-2012,VAR_1D,317211 09-11-2012,VAR_10D,317211 09-11-2012,CB,985 09-11-2012,JOB,640 09-11-2012,STR_VAR_1D,305364 09-11-2012,STR_VAR_10D,317211 I have a flat file like ab

I have an input list of:

Quote:

2/10/2012 9:19 PM EST 2/10/2012 8:48 PM EST 2/16/2012 2:49 PM EST 2/16/2012 6:06 PM EST 2/14/2012 8:30 PM EST 2/13/2012 2:44 PM EST 2/13/2012 6:06 PM EST 2/14/2012 4:36 PM EST 2/11/2012 7:01 PM EST 2/16/2012 11:48 AM EST 2/15/2012 6:16 PM EST 2/13/2012 12:59 PM EST

I am just trying to turn this list into its seconds

when i run this command:

Code: tail -200 /var/log/httpd/access_log | awk -F'[][]' '{sub(/:[^:]*$/,"",$2);print $2}' i get:

Code: 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 now i need to alter the awk command

I have an SQL fact table which is used for looking up a date and returning another date.

The table schema is as follows:

TABLE date_lookup ( pk_date DATE, plus1_months DATE, plus2_months DATE, plus3_months DATE );

UNIQUE INDEX on date_lookup(pk_date);

I have a load file (pipe delimited) containing dates from 01-28-2012 to 03-31-2014.

The following is an example of the load file:

01-2

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!

1.

The error is 2147746321.

I can see in the mailserver log that it tries, but the connection gets closed.