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

17 votes236 views8 answers
Jupyter notebook
Shell/Bash
0 vote220 views1 answer
How to reset back to commit id in git
Shell/Bash
46 votes289 views6 answers
Git Commands List
Shell/Bash
0 vote251 views1 answer
How to install comoposer without show dependecies in laravel
Shell/Bash
1 vote260 views1 answer
Delete network
Shell/Bash
1 vote264 views1 answer
Installing debian files
Shell/Bash
1 vote258 views1 answer
How to open explorer in wsl linux directory
Shell/Bash
0 vote226 views1 answer
Phpall version extension installation command on centos 7
Shell/Bash
0 vote238 views1 answer
How to deploy react and backend to github pages
Shell/Bash
1 vote258 views1 answer
Linux shell echo command with varia ble
Shell/Bash