Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

join 2 tables based on same id

hI,

I am having 2 tables wit same id.how to join that 2 tables based on id. shall i use join or mapping function...

1 Solution

Accepted Solutions
Not applicable

Re: join 2 tables based on same id

Hi,

load fields from tables like this:

LOAD

"Table1_id" as [ID]

....

LOAD

"Table2_id" as [ID]

...

just give the fields you want to join the same name.

Regards

3 Replies

join 2 tables based on same id

Hi,

   No need to use join or mapping.

   Load both the table. Qlikview will automatically join based in similar names in both the tables.

   By default qlikview uses outter join.

Regards,

Kaushik Solanki

Not applicable

Re: join 2 tables based on same id

Hi,

load fields from tables like this:

LOAD

"Table1_id" as [ID]

....

LOAD

"Table2_id" as [ID]

...

just give the fields you want to join the same name.

Regards

Not applicable

join 2 tables based on same id

YEAH ITS WORKING...