Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created a table with several join (left and outer) and then I am doing a resident load with a where clause in which I want to eliminate the records with certain seller type positions-(see the syntax below). I don't get any error running the script but it is not eliminating the records with Seller type I have in where clause and is essentially bringing all records. Can someone help? IS it also possible to write the 3 seller type positions in the list form?
Any guidance on this will be really appreciated
Regards,
Monica
====================================================================
Stages:
NoConcatenate
LOAD *
Resident All_Stages
where [Seller Type] <> 'SIG MM' OR [Seller Type] <> 'SIG SM' OR [Seller Type] <> 'CST';
Drop Table All_Stages;
=====================================================================
This should have worked, may be try this:
Stages:
NoConcatenate
LOAD *
Resident All_Stages
Where not Match([Seller Type], 'SIG MM', 'SIG SM', 'CST');
Drop Table All_Stages;
This should have worked, may be try this:
Stages:
NoConcatenate
LOAD *
Resident All_Stages
Where not Match([Seller Type], 'SIG MM', 'SIG SM', 'CST');
Drop Table All_Stages;
THAT WORKED. THANKS.