I am attempting to run a fuzzy match on some customer data and reduce the list to as few records as possible, as an employee will have to review the data and make decisions. I am encountering an issue where there are line breaks/carriage returns in my file, which is causing a number of duplicate records that have a match score of 0 because it's treating it like a separate unique value. It's not entirely apparent when looking at the data to know which records are duplicated because of this.
I am looking for a way to remove all line breaks/carriage returns from a singular column within my dataset. I have attempted to use the data cleansing tool to remove these line breaks, but it is not working. I have also tried using the text to columns and trim features in excel, but those did not work either. Are there any other suggestions on how I could do this within Alteryx?
Thanks!
