Filtering data in a table.

[wgonzalez]

Hi,

In a pivot table QV is showing all transactions in table Trans even if there is no corresponding record in table Emp. That's because Trans is a history table having all the transactions, while Emp has active employees only.  I don't want QV to show transactions that does not have a corresponding associated record in the Emp table. 

In SQL I can filter data in a table to get a selected group of records, I would do this:

select EmpID, Date, Transtype

from Emp, Trans

where Emp;.EmpID = Trans.EmpID

How would I do the same in QV?

Can I use a Set Modifier to use to perform that or should I do it in the script?

Thanks.

[#2]

you mean you've got two separete tables in QV? (check Ctrl+T)

[wgonzalez]

Yes, one for employees and another for transactions.  It has its purpose.

[MayilVahanan]

HI,

     You can use inner join both the table like,

     Load * from TableA;

     inner join(TableA)

     Load * from TableB;

     (or)

     Simply concatenate both table

     Load * from TableA;

     Concantenate(TableA)

     Load * from TableB;

     (or)

     Use can use exists functionality too,

     Load *,Id as TransId from TableA;

     Load *,Id as TransId from TableB where exists(Id,TransId);

     Hope it helps

[wgonzalez]

Thanks Mayil!