I have two files.

I want to match the 1st column of first file to 1st column of second file. If there is a match I'd like to print the 2st column of second file, if not 0.

I have tried awk (awk 'FNR==NR{a[$1]=$0;next} {print a[$1]}' 2.txt 1.txt) but it is not working.

F1.txt

A

B

C

D

E

F

G

H

I

J

F2.txt

A 0.5

E 1

H 0.5

J 1

Desired_output

A 0.5

B 0

C 0

D 0

E 1

F 0

G 0

H 0.5

I 0

J 1

I have two files.

I want to match the 1st column of first file to 1st column of second file. If there is a match I'd like to print the 2st column of second file, if not 0.

I have tried awk (awk 'FNR==NR{a[$1]=$0;next} {print a[$1]}' 2.txt 1.txt) but it is not working.

F1.txt

A B C D E F G H I J 

F2.txt

A 0.5 E 1 H 0.5 J 1 

Desired_output

A 0.5 B 0 C 0 D 0 E 1 F 0 G 0 H 0.5 I 0 J 1