If one column have the same value in two files i want to replace all values in row but if not do not change value
file1
M BD0001 Parent Bank
M BD0002 Children Bank
M BD0003 Member Bank
file2
A BD0001 Member Bank
A BD0003 Children Bank
Output
A BD0001 Member Bank
M BD0002 Children Bank
A BD0003 Children Bank
I was trying do it using join but i know only how to replace all rows from file1 by rows from file2 if key match but the data which not match was removed.
