Link to home
Start Free TrialLog in
Avatar of zhshqzyc
zhshqzyc

asked on

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

Open in new window

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

Open in new window

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

Open in new window

Avatar of zhshqzyc
zhshqzyc

ASKER

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

Thanks for help.
Avatar of AndyAinscow
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.
I am sorry, I can't follow you. I don't understand your comment. It is a different question.
ASKER CERTIFIED SOLUTION
Avatar of Todd Gerbert
Todd Gerbert
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 

Open in new window

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks you. I will try it by myself.