6 Replies Latest reply: Oct 30, 2017 11:36 PM by ramesh konda RSS

    Joining data on two tables

    ramesh konda

      I have Two Load Statements as below

      [Table1]:

      Load a,b,c,d from ...;

      [Table2]:

      Load a,b,d,e,f from ....;

       

      Can we write a statement where table3 which holds a,b,c,d,e,f [ I tried to create a new table3 using JOIN between table1 and table2  what i have found the issue was im able to see the null values for c,d / e,f . My Intention is i don't want to have nulls i want full data for a,b,c,d,e,f columns.

       

      i want to merge vertically of Two tables like from table1 (a,b,c,d) columns with table2 ( e,f) columns.

       

      --Rams