Hi Guys,
I have several files that look like this:
File 1:
location number1 position
1 6 A
2 8.9 A
3 4.8 B
4 10.52 B
5 15.87 B
----
File 2:
location number2 position
1 6.9 A
2 8.9 A
3 4.8 B
4 10.52 B
5 15.87 B
----
File 3:
location number3 position
1 7.89 A
2 8.9 A
3 4.8 B
4 10.52 B
5 15.87 B
-----
I want a file that looks like:
location number1 number2 number3 position
1 6 6.9 7.89 A
2 8.9 8.9 8.9 A
3 4.8 4.8 4.8 B
4 10.52 10.52 10.52 B
5 15.87 15.87 15.87 B
---
All the values under the number1, number2 and number3 columns are different for different files.
How do I achieve this?
I tried the join command and it did not work.
Thanks.