[Solved] How to merge two files with different fields based on one matching columns?
Could you please try following and let me know if this helps you.(I have kept the order of NA at last only let me know if this helps you). Adding a non-one liner form of solution too here. awk ‘ FNR==NR{ a[$1]=$0; next } ($1 in a){ print a[$1],$0; b[$1]; next } { print “NA\t”,$0 … Read more