Joining 2 resident tables

[krisslax]

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.

[martinpohl · Accepted solution]

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]

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