Your code would look like this:
[AFTER YOU LOADED BOTH TABLES....]
Load * resident RevenueDetails;
left join (RevenueDetails)
Load *, 1 as flag
Load distinct Carrier_No resident TEMP where flag<>1;
drop table TEMP
store differences into differences.qvd;
drop table differnces;
Thanks for your reply. I was not able to follow your answer as I was supposed to meet smone sort of deadline. So, I implemented in my way.
During the load of data from QVD I outer joined 2 tables.
LOAD * FROM Revenue.qvd
LOAD * FROM Market.QVD
LOAD Carrier_No RESIDENT Revenue_Temp
WHERE NOT EXISTS(Group_No); //Group_No is a clolumn from Market Table which is not there in Revenue Table.
Sorry for replying late. I will definitely check and mark your answer.
Thanks for your reply again,