Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

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