Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-06-27 01:43 AM

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,061 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2011-06-27 02:02 AM
Author

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

View solution in original post

607 Views
0 Likes
3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2011-06-27 01:52 AM

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
607 Views
Not applicable
‎2011-06-27 02:02 AM
Author

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

608 Views
0 Likes
Not applicable
‎2011-06-27 02:09 AM
Author

In response to kaushiknsolanki

YEAH ITS WORKING...

607 Views
0 Likes