I have multiple files, each with two columns :
For example :
file1.txt
ID Value1
1 40
2 30
3 70
file2.txt
ID Value2
3 50
4 70
9 20
And so on,
file1230.txt
ID Value150
9 98
10 52
2 71
How do I merge these files based on the first column (based on the intersections between the files)? My output should be
ID Value1 Value2 Value150
1 40 0 0
2 30 0 71
3 70 50 0
4 0 70 0
9 0 20 98
10 0 0 52
Could someone help to this using awk or Linux commands.
Thank you.