help with joins exclusions

[ioannagr]

Hi i've got this code

Source_Table:

LOAD

TestID,

TestType,

PlaceOfTest

from sourcetable;



right join( Source_Table)

//TestTypes_A:

LOAD

TestID,

Result

from testtypesA_results;

So this way i get all the information for TestTypes_A from the source Table.

The thing is that I want one PlaceOfTest to be excluded AFTER the join happens.

How do i do this?

Is it correct if I add

JOIN(Source_Table)

LOAD * 

RESIDENT Source_Table

where PlaceOfTest<>'1';

?

Your help, will be, as everytime, huge! Thank you in advance

[Taoufiq_Zarra]

@ioannagr  if you want to do it after Join, you can test :

Source_Table:

LOAD

TestID,

TestType,

PlaceOfTest

from sourcetable;



right join( Source_Table)

//TestTypes_A:

LOAD

TestID,

Result

from testtypesA_results;

Final:
noconcatenate

laod * resident Source_Table where PlaceOfTest<>'1';

drop table Source_Table;

[ioannagr]

I'm trying this right now, it will take some time to load, but i will let you know  how this went@Taoufiq_Zarra  🙂 Thank you for your speedy response!