Not removing all the items when making a filter

[GdeH]

Hi, 

In another tool, 2 files were compiled together in 1 file. 

I've added this one file to the alteryx workflow. In this file I've the following columns:

File Name	Email Adres
File 1	@gmail.com
File 1	@hotmail.com
File 1	@skynet.com
File 2	@gmail.com
File 2	@hotmail.com
File 2	@skynet.com

I would like to exclude all the items containing @skynet adresses from the database. Therefore I've used the filter tool in order to and obtain this: 

File Name	Email Adres
File 1	@gmail.com
File 1	@hotmail.com
File 2	@gmail.com
File 2	@hotmail.com

However I obtain this: 

File Name	Email Adres
File 1	@gmail.com
File 1	@hotmail.com
File 2	@gmail.com
File 2	@hotmail.com
File 2	@skynet.com

I do not understand why it is exclude this from the first file and not from the 2nd file. 

What could be the reason behind this?

Thank you

[JulioMO · Accepted solution]

Hi @GdeH 

Is it possible that you have a whitespace trailing "@skynet.com"? Try adding a "Data Cleansing" Tool and remove all possible whitespaces (Select the checkbox "Leading and Trailing Whitespace").

Regards

[echuong1 · Accepted solution]

You should be able to just create a standard filter for it. You may have extra spaces before and after, which a data cleansing can help.