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
@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;
Regards, Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
