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 vote209 views1 answer
Odoo 13 install
Shell/Bash
1 vote199 views1 answer
Composer require laravel/ui app.css empty
Shell/Bash
6 votes184 views5 answers
Add label to pod kubectl
Shell/Bash
0 vote202 views1 answer
Initramfs ubuntu 20.04
Shell/Bash
0 vote205 views1 answer
Windows show environment variables powershell
Shell/Bash
2 votes193 views1 answer
Wps office download for ubuntu
Shell/Bash
-2 votes247 views4 answers
Install GUI centos 7
Shell/Bash
0 vote195 views1 answer
Yaml file example ubuntu netplan error
Shell/Bash
1 vote204 views1 answer
Wget pause download
Shell/Bash
1 vote211 views1 answer
Ubuntu snap install device not yet seeded
Shell/Bash