picking certain rows based on certain word

[kauser]

can someone help me how to pick certain rows based on certain words. 

Input Data 

Type	Item	Exp	Income
YELLOW	A	50	100
GREEN	B	60	220
RED	C	40	540
BLACK	D	20	620
WHITE	E	56	260
ORANGE	F	65	584
YELLOW	G	70	600
BLUE	Y	80	400

Output Data- 

Type	Item	Exp	Income
GREEN	B	60	220
RED	C	40	540
BLACK	D	20	620
WHITE	E	56	260
ORANGE	F	65	584

[jrlindem]

There's a number of ways you can do this.

One is using a Filter Tool.  If you know the values you don't want, you can specify those in your Filter logic and then just move downstream with the values that you do want (true vs false path):

The Filter function I used is:  [Type] != "YELLOW" AND [Type] != "BLUE"

If your list is longer, and it doesn't make sense to build a big long filter function, then you can list the values in a separate Text Input Tool and have that act as a crosswalk.  Then you JOIN this to your original data and just keep the LEFT stream:

[Qiu]

@kauser 
What is the criterial for picking certain rows?