How to do a join of 3 files with awk by first Column?
Posted
by noinflection
on Stack Overflow
See other posts from Stack Overflow
or by noinflection
Published on 2010-05-12T04:00:07Z
Indexed on
2010/05/12
4:04 UTC
Read the original article
Hit count: 379
i have three similar files, they are all like this:
ID1 Value1a
ID2 Value2a
.
.
.
IDN Value2n
and i want an output like this
ID1 Value1a Value1b Value1c
ID2 Value2a Value2b Value2c
.....
IDN ValueNa ValueNb ValueNc
Looking to the first line i want value1A to be the value of id1 in fileA, value1B the value of id1 in fileB, etc, i think of it like a nice sql join. I've tried several things but none of them where even close.
© Stack Overflow or respective owner