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!
Best answer by hkingsbury
@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)
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?
+65@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 😉
