Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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;
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!