Bash vlookup function

# Example usage:
awk 'FNR==NR{a[$1]=$2; next}; {if($9 in a) {print $0, "\t"a[$9];} else {print $0, "\tNA"}}' input_file_1 input_file_2
# This command does a VLOOKUP-type operation between two files using
#	awk. With the numbers above, column 1 from input_file_1 is used 
#	an a key in an array with column 2 of input_file_1 as the match for 
#	the key. Column 9 of input_file_2 is then compared to the keys from
#	input_file_1 and any matches return the associated match from 
#	input_file_1 (here, column 2).

Source: unix.stackexchange.com

Similar codes

1 vote173 views1 answer
Show detail all changes in a git log
Shell/Bash
44 votes175 views6 answers
Install sklearn
Shell/Bash
0 vote187 views1 answer
Uninstall minikube ubuntu 20.04
Shell/Bash
0 vote164 views1 answer
This site can’t be reached
Shell/Bash
3 votes166 views2 answers
Ngrok brew
Shell/Bash
0 vote127 views1 answer
Find exec rm
Shell/Bash
5 votes186 views2 answers
Find folder in centos 8
Shell/Bash
0 vote168 views1 answer
View live log linux
Shell/Bash
48 votes172 views6 answers
Yarn ubuntu
Shell/Bash
0 vote181 views1 answer
Linux find string in files in path
Shell/Bash