I have two datasets namely A and B.
A has 400 columns in which only column number 18 is not filled(Blank).
B has 400 columns in which only column number 18 and Key (column 1) is filled and remaining all are missing(numeric) or blank(Char) based on the data type.
Now I want new dataset as follow:
If match on key between A and B: I want all columns of A with columns number 18 having value of dataset B.
If exist in B and not A then I want all records in B.(Meaning columns1 and columns 18 filled and remaining missing or blank).