Joining data on two tables

[Anonymous]

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

[OmarBenSalem]

if you want to just keep the exsting combination btwn the 2 table; use inner join

[OmarBenSalem]

[Table1]:

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

inner join(Table1)

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

[Anonymous]

Omar, Thanks for the response.

I tried it But Still giving Nulls for the other columns.

[MK9885]

Different Join Functions in Qlikview

[OmarBenSalem]

you sure about that??

[Anonymous]

Will share the screenshot, if possible.

As it is sensitive data will let you know.