topic Re: data from two resident table in QlikView

data from two resident table

Thu, 20 Dec 2012 10:27:33 GMT

I have created two resident table .

now i want data from those two table based on condition .

for eg

table1:

select

b ,

from database

table 2

load

from uvw.xlx

now i want to pull data from these two tables upon some condition

is thera ny way to do it .

for eg

a.[FieldA], a.[FieldB], b.[FieldD], sum(a.[FieldC]) as FieldX

resident Table1 a, resident Table2 b

where a.[FieldA] = b.[FieldA]

group by a.[FieldA], a.[FieldB], b.[FieldD]

order by a.[FieldA], a.[FieldB], b.[FieldD]

Re: data from two resident table

Gysbert_Wassenaar — Thu, 20 Dec 2012 10:31:13 GMT

A resident load accepts only one table as input.

where a.[FieldA] = b.[FieldA]

If both tables have a FieldA then you can join the two tables so you end up with one table. You can then use that table in a resident load to calculate the sum.

Re: data from two resident table

er_mohit — Thu, 20 Dec 2012 11:57:59 GMT

drop table2

sort by b.[FieldD]