Shell Programming and Scripting

file1:
No;age;id;name
1;24;37h;name1
2;22;67e;name2
4;48;9r;name3
6;67;9i8;name4

file2:
exp;id;pos
23;9r;hr
15;67e;tec


Expected new file output:

No;age;id;name;exp;pos
4;28;9r;name3;23;hr
2;24;37h;name1;15;tec

awk -F";" 'NR==FNR{a[$2]=$1FS$3;next} a[$3]{print $0 FS a[$3]}' file2 file1  > outputfile

awk -F";" 'NR==FNR{a[$2]=$1 OFS $3;next} a[$3]{print $0,a[$3]}' OFS=\; file2 file1

awk '
	BEGIN{
			FS=OFS=";"	# declare input Field Separator and Output Field Separator variable and set the value to ;
		}
	NR==FNR{
			a[$2]=$1 OFS $3 # store file2 information in array a indexed by key field 2 having the value of two fields(1 and 3) separated by OFS
		} 
	$3 in a{			# process the second (or subsequent) files, in this case file1, If field 3 is found as indexes in array a
			print $0,a[$3]	# print the whole record ($0) of file1 follow by the index of array a having the key field 3 of file1
		}
' file2 file1

Expected new file output:

No;age;id;name;exp;pos
4;48;9r;name3;23;hr
2;24;37h;name1;15;tec

awk -F";" 'NR==FNR{a[$3]=$0;next} a[$2]{print a[$2] FS $1 FS $3}' file1 file2