Not removing all the items when making a filter

Question

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 NameEmail AdresFile 1@gmail.comFile 1@hotmail.comFile 1@skynet.comFile 2@gmail.comFile 2@hotmail.comFile 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 NameEmail AdresFile 1@gmail.comFile 1@hotmail.comFile 2@gmail.comFile 2@hotmail.com

However I obtain this:

File NameEmail AdresFile 1@gmail.comFile 1@hotmail.comFile 2@gmail.comFile 2@hotmail.comFile 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 Answer

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 Answer

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.