[Solved] How to merge two files with different fields based on one matching columns?
[ad_1] 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 … Read more