Skip to main content

I would like to filter my dataset based on addresses that don't match. The Tester is not giving the expected output. Please see the screenshots below:

 

The first screenshot (Tester1) is of Tester Parameters box where I have set the addresses of the joined dataset to not equal each other.

 

The second screenshot (Tester2) shows the transformer output and as you can see the addresses are the same.

 

Thank you for your help!

 

 

Have you checked that either of the strings don't have trailing spaces?


Have you checked that either of the strings don't have trailing spaces?

@hkingsbury​  No, I haven't checked that. Can you please recommend a transformer to use?


@hkingsbury​  No, I haven't checked that. Can you please recommend a transformer to use?

The AttributeTrimmer will do the job, set the trim character to ' ' (a single space)


@hkingsbury​  No, I haven't checked that. Can you please recommend a transformer to use?

@hkingsbury​  I removed the white space with the AttributeTrimmer but am still getting the same results.


@hkingsbury​  No, I haven't checked that. Can you please recommend a transformer to use?

@hkingsbury​  I set the parameters to remove the white space from the front and end of the line and it worked! Thanks 😉


Reply