Very Computer

> Hi

> I have two tab-delimited flat files. Both have column x coordinate and y
> coordinate. I want to join them by using their coordinate as the key
> (which should include both x and y coordinate). Is there way to do this
> using shell commands sort and join, etc? Thanks a lot! (only those
> coordinates in file1 will be appeared in final merged results). -Yong

> File 1:
> x y number1
> 1 2   343.5
> 1 3   444.2
> 0 1   33.4

> File 2:

> x y number2
> 0 1 333
> 1 2 444
> 1 3 555
> 0 8 666

> Merge results:
> x y number1 number2
> 1 2 343.5    444
> 1 3 444.2    555
> 0 1 33.4     333

> Hi

> I have two tab-delimited flat files. Both have column x coordinate and y
> coordinate. I want to join them by using their coordinate as the key
> (which should include both x and y coordinate). Is there way to do this
> using shell commands sort and join, etc? Thanks a lot! (only those
> coordinates in file1 will be appeared in final merged results). -Yong

> File 1:
> x y number1
> 1 2   343.5
> 1 3   444.2
> 0 1   33.4

> File 2:

> x y number2
> 0 1 333
> 1 2 444
> 1 3 555
> 0 8 666

> Merge results:
> x y number1 number2
> 1 2 343.5    444
> 1 3 444.2    555
> 0 1 33.4     333

> I have two tab-delimited flat files. Both have column x coordinate and y
> coordinate. I want to join them by using their coordinate as the key
> (which should include both x and y coordinate). Is there way to do this
> using shell commands sort and join, etc? Thanks a lot! (only those
> coordinates in file1 will be appeared in final merged results). -Yong

> File 1:       > File 2:         > Merge results:
> x y number1   >                 > x y number1 number2
> 1 2   343.5   > x y number2     > 1 2 343.5    444
> 1 3   444.2   > 0 1 333         > 1 3 444.2    555
> 0 1   33.4    > 1 2 444         > 0 1 33.4     333
>               > 1 3 555
>               > 0 8 666

> Hi

> I have two tab-delimited flat files. Both have column x coordinate and y
> coordinate. I want to join them by using their coordinate as the key
> (which should include both x and y coordinate). Is there way to do this
> using shell commands sort and join, etc? Thanks a lot! (only those
> coordinates in file1 will be appeared in final merged results). -Yong

> File 1:
> x y number1
> 1 2   343.5
> 1 3   444.2
> 0 1   33.4

> File 2:

> x y number2
> 0 1 333
> 1 2 444
> 1 3 555
> 0 8 666

> Merge results:
> x y number1 number2
> 1 2 343.5    444
> 1 3 444.2    555
> 0 1 33.4     333

> Hi

> I have two tab-delimited flat files. Both have column x coordinate and y
> coordinate. I want to join them by using their coordinate as the key
> (which should include both x and y coordinate). Is there way to do this
> using shell commands sort and join, etc? Thanks a lot! (only those
> coordinates in file1 will be appeared in final merged results). -Yong

> File 1:
> x y number1
> 1 2   343.5
> 1 3   444.2
> 0 1   33.4

> File 2:

> x y number2
> 0 1 333
> 1 2 444
> 1 3 555
> 0 8 666

> Merge results:
> x y number1 number2
> 1 2 343.5    444
> 1 3 444.2    555
> 0 1 33.4     333