Join two files and get the matching records on shell scripting

I have two files both files are separated by delimiter we need to join these two files and send the matching records to out_file on the first file key column is 1st column and in the second file 3rd column is the key column and on out_file i need all the columns from first file and only 6th columns from second file

Sample files

Note:Original files has 90+ records and both the files are unsorted)

File1:

Username| Status| Managername
4115    |  Open  | X
234      | Expired |Y

File2:

Id| Name| Username| type| role| Access
1| User1| 4115| primary| connect| Never
2|User|432|Nonuser|conect|Never

OutputFile

Username| Status| Managername| Access
4115    |  Open  | X |Never

I have tried this but this is giving all the records from both the files:

join -a 2  -t "|" -1 1 -2 3 file1 file2>out_file

awk -F' *[|] *' 'FNR==NR { a[$3]=$6; next } $1 in a { print $0 " | " a[$1] }' File2 File1

prints

Username| Status| Managername | Access
4115    |  Open  | X | Never

Note that File2 is specified first.

Explanation:

• -F' *[|] *' = set | with optional spaces before and after as input field separator
• FNR==NR = condition that is true for the first file only (file record number == total record number)
• a[$3]=$6 = store 3rd field (from File2) as key with 6th field as value in array a
• next = skip further processing, continue with next line. This makes sure all following code is executed for the second and following files only.
• $1 in a = condition if the 1st field is present as a key in a
• print $0 " | " a[$1] print the current input line (from File1) followed by a separator and the value from a matching the key