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

0 vote318 views1 answer
Install tekton on kubernetes
Shell/Bash
0 vote226 views1 answer
Linunx reload shell
Shell/Bash
1 vote206 views1 answer
Mongodb recherche like
Shell/Bash
4 votes248 views6 answers
Touch command in windows
Shell/Bash
24 votes238 views5 answers
Git reset head of master
Shell/Bash
8 votes316 views3 answers
Npm install firebase @angular/fire
Shell/Bash
1 vote210 views1 answer
Gitaarles amsterdam
Shell/Bash
0 vote229 views1 answer
Where is the jenkins_home variable in bunutu
Shell/Bash
33 votes220 views3 answers
How to install scikit learn python library
Shell/Bash
0 vote199 views1 answer
Raspberry clear cache
Shell/Bash