asked on 5/17/2011

Combine multiple files

Hi, I have many file s to be combined. Ex,
File 1

ID  h1 h2 h3
a   1  5  7
b   3  3  5
c   0  4  8

File 2

ID h4 h5 h6
a  2  4  9
b  3  6  1
f  4  1  5

Expected files

ID  h1  h2  h3  h4 h5  h6
a   1   5   7   2   4   9 
b   3   3   5   3   6   1
c   0   4   8 
f               4   1   5

Last Comment

5/17/2011

5/17/2011

ASKER

There is a similar solution at here
How can I apply the priciple?

Thanks for help.

5/17/2011

What is wrong with the comment you accepted as solution in your other post? If it doesn't work then request that it be reopened.

5/17/2011

ASKER

I am sorry, I can't follow you. I don't understand your comment. It is a different question.

ASKER CERTIFIED SOLUTION

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

5/17/2011

ASKER

Okay. Thanks for advice. A little modification. If ID is in the second column, how to modify the code?

h1 ID  h2  h3
1   a   5   7
3   b   3   5
0   c   4   8

SOLUTION

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

5/17/2011

ASKER

Thanks you. I will try it by myself.