Shell Programming and Scripting

Can you post sample data that is giving incorrect output as well as the desired output?

Incorrect Output:

1 STATUS 60462578 60933968
2 CMPGNPT 75389063 75389063
3 LEADHIST 1716608 1716608
4 INBNDCN 13039079 13039079
5 MOD 21915188 22071450
6 DLGSCRS 5615481 5615481
7 PROS 41398096 41398096
8 CMPHST 44773566 47099303
9 PRSFINC 6737299 6737299

Desired Output:

1 STATUS 60462578 60933968
2 CMPGNPT 75389063 75389063
3 LEADHIST 1716608 1716608
4 INBNDCN 13039079 13039079
5 MOD 21915188 22071450
6 DLGSCRS 5615481 5615481
7 PROS 41398096 41398096
8 CMPHST 44773566 47099303
9 PRSFINC 6737299 6737299
10 PGNSCOR 773422 773422
11 respshist 22844444 22846172
12 commhist 48543695 49093924
13 commsta 55229204 55229204
14 INTRTHIST 9723948 9885086


Just these 10-14 records are not coming.......

You didn't post your input data...

Input 1:

1 STATUS 60462578
2 CMPGNPT 75389063
3 LEADHIST 1716608
4 INBNDCN 13039079
5 MOD 21915188
6 DLGSCRS 5615481
7 PROS 41398096
8 CMPHST 44773566
9 PRSFINC 6737299
10 PGNSCOR 773422
11 respshist 22844444
12 commhist 48543695
13 commsta 55229204
14 INTRTHIST 9723948



Input 2:

1 imstatus.load 60933968
2 immtnhist.load 75389063
3 imadhistory.load 1716608
4 imcntcthist.load 13039079
5 imccist.load 22071450
6 imccscrs.load 5615481
7 imcospect.load 41398096
8 imccmpdlrhst.load 47099303
9 imctcmpgnfinc.load 6737299
10 imcctcmpgnscor.load 773422
11 imcrespshist.load 22846172
12 imclecommhist.load 49093924
13 imcagevci.load 55229204
14 imcclofintrthist.load 9885086

All are separated using Tab.

Desired out put is:

Column 1 is serial numbers (col 1 from Input 1 or 2), Column 2 is from input_1 Col 2, Column 3 is input_1 col 3, Column 4 is input_2 col 3.

For that I wrote the syntax as mentioned before, but 10-14 records are missing in the output.

This is weird, cause I get correct output for this data:

Code:

1 STATUS 60462578 60933968
2 CMPGNPT 75389063 75389063
3 LEADHIST 1716608 1716608
4 INBNDCN 13039079 13039079
5 MOD 21915188 22071450
6 DLGSCRS 5615481 5615481
7 PROS 41398096 41398096
8 CMPHST 44773566 47099303
9 PRSFINC 6737299 6737299
10 PGNSCOR 773422 773422
11 respshist 22844444 22846172
12 commhist 48543695 49093924
13 commsta 55229204 55229204
14 INTRTHIST 9723948 9885086

Can you post output of:

Code:

cat -Te file1
cat -Te file2

Can you post output of:

Code:

cat -Te file1
cat -Te file2

[/QUOTE]

cat: Not a recognized flag: T
Usage: cat [-qrSsu] [-n[b]] [-v[et]] [-|File ...]

join is not appropriate for this problem, at least not without some further processing. The key you are trying to join on is not properly sorted. It is sorted numerically but the standard says requires that "The files ... shall be ordered in the collating sequence of sort -b on the fields on which they shall be joined".

To make this work, you'd have to pre-sort each of the files, on the first field, so that the order is similar to 1, 10, 2, 20 ... instead of 1, 2, 10, 20 ... run the join, and finally numerically sort the result on the first column.

Regards,
Alister