Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
krisslax
Contributor II
Contributor II

Joining 2 resident tables

Hi, I have 2 resident tables which I'm trying to join, I'm new to Qlik and having a little bit of a hard time adjusting my thinking from purely SQL to Qlik so any advice would be gratefully received.

Summary_Table:

LOAD  Asset_ID, Asset_Name, Asset_Status

RESIDENT Assets_Table;

What I want to do is count how many records exist in Work_Orders that match the value of Asset_ID and add it as an additional column in the Summary_Table.

 

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

hello,

something like

left join (Summary_Table) load

Asset_ID,

count(Aesset_ID) as Count_Work_orders

resident Work_Orders group by Asset_ID;

 

regards

View solution in original post

2 Replies
martinpohl
Partner - Master
Partner - Master

hello,

something like

left join (Summary_Table) load

Asset_ID,

count(Aesset_ID) as Count_Work_orders

resident Work_Orders group by Asset_ID;

 

regards

krisslax
Contributor II
Contributor II
Author

Martin - that is superb, thank you so much, I put it into place and it worked first time.

Even better, now seeing it in action I was able to understand HOW it works so it's been very useful for my learning curve.

Many, MANY thanks