Harsha3
5 years agoNew Contributor III
Queries in merging two tables
Good Day,
We need to perform a simple activity where I used outer join and merge . The purpose of merge is to actually unite both the tables to proceed further . Since the entries present in the result table are not in source table , there are null entries which are expected . I would like to replace all the null values with the values of the present in the source table . I provide screenshot for better clarity.
Table 1: ( Source table )
Table 2: ( After performing join)
Merged result (Merging Table 1 and Table 2 ):
Expected Output:
--Wanted all the null values exactly to be replaced with the value present in the first row . Is there any way to do the same.
Thanks,
Harshaavrdhana