help me to ignore the records based on condition?

[durgabhavani]

Hi All,

Please help me to ignore the records if the emp having the Emp Code SE1. please find my data and expected out put and advice.

My data:

Emp ID	Emp Name	Emp code
101	Ravi	SE1
101	Ravi	TL1
102	Suresh	SE1
103	Satish	SSE1
104	Ramesh	SE1
104	Ramesh	PM
105	Venkat	PM

Expected out put.

Emp ID	Emp Name	Emp code
103	Satish	SSE1
105	Venkat	PM

please help me to achieve the above output.

Thanks,

Durga

[durgabhavani]

Kushal,

The above code will bring below record. but i dont want the other records as well having 101 id.

101, Ravi, TL,1

[goro2010]

Maybe try this:

testting:

LOAD * Inline [

Emp ID, Emp Name, Emp code

101, Ravi, SE1

101, Ravi, TL,1

102, Suresh, SE1

103, Satish, SSE1

104, Ramesh, SE1

104, Ramesh, PM

105, Venkat, PM

];

Test2:

LOAD * resident testting

Where Match([Emp code], 'TL1', 'SSE1', 'PM');

Drop Table testting;

In the where match, you can identify all the required data field names that must be selected within [Emp code]

Thank You

[Kushal_Chawda]

No it will not bring that record. Have you tried it?