Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting Feilds from 2 Resident Tables

Hi all,

Is there a way that you can select certain feilds from 2 tables already loaded as a sub table, essentially using a join in a resident statement.

4 Replies
Anonymous
Not applicable
Author

Yes, you can :).

Not applicable
Author

10 points...now can you show me some code... Big Smile....please

Anonymous
Not applicable
Author


product_sales:
load
product,
group,
listprice
resident prod;
left join
load
product,
quantity
resident sales


If you want in the same time to do listprice* cantity you have to load the table product_sale again ad do the calculations.

Not applicable
Author

thanks...