Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if you want to just keep the exsting combination btwn the 2 table; use inner join
[Table1]:
Load a,b,c,d from ...;
inner join(Table1)
Load a,b,d,e,f from ....;
Omar, Thanks for the response.
I tried it But Still giving Nulls for the other columns.
you sure about that??
Will share the screenshot, if possible.
As it is sensitive data will let you know.