Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramshoney
Contributor

Joining data on two tables

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

6 Replies
OmarBenSalem
Esteemed Contributor

Re: Joining data on two tables

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

OmarBenSalem
Esteemed Contributor

Re: Joining data on two tables

[Table1]:

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

inner join(Table1)

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

ramshoney
Contributor

Re: Joining data on two tables

Omar, Thanks for the response.

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

Khan_Mohammed
Honored Contributor II

Re: Joining data on two tables

OmarBenSalem
Esteemed Contributor

Re: Joining data on two tables

you sure about that??

ramshoney
Contributor

Re: Joining data on two tables

Will share the screenshot, if possible.

As it is sensitive data will let you know.

Community Browser