LOAD from Resident table with condition and apply Map

Anonymous — Wed, 28 Jan 2015 08:35:58 GMT

Hi guys ,

i have 3 tables Table1 ,table2 and table3

Table1 has fields : RefID ,etc...

Table2 also has RefID and so..

same as Table3

now my issue is :-

i load Table 1 first and then table2 but table2 needs to have only records where table2.RefID is in Table1.RefID

and as well Table3 will only load records that are in Table2.RefID along with a condition where Table3.Active=1

Would there be a way to flag if RefID exits in table1.RefID ,Table2.RefID and Table3.RefID

Thanx

Re: LOAD from Resident table with condition and apply Map

marcus_sommer — Wed, 28 Jan 2015 09:04:54 GMT

Try something like this:

t1:

Load * From a;

t2:

Load * From b where exists(RefID);

t3:

Noconcatenate Load * Resident t2 where Active =1;

- Marcus