Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Trailing Space Duplicates

Hi All,   Came across something the other day which may be of use to someone....   I was creating a list to use as intermediate data so that I could create a relationship between two non-unique c...
General Comment
Show and Tell
rorromartins's avatar
rorromartins
Frequent Visitor
8 years ago

Mark, I'm having a similar issue regarding this topic.

 

In my case, I need to have these "duplicate" values (with extra spaces in some cases) because it links them to a dictionary that replaces that value with a correct value. (E.G. I have "HELLO SAM", "HELLO SAM ", "HELLO  SAM"(double spacing), "hello sam", "helo sam", and "hello sam!" and I want them all to show "Hello Sam").

 

But when I try to link this intermediate list to the Base and the Dictionaries I can't because the relationship manager considers some of these values as duplicates (The cases with double spacing between words or extra space at the end of the text).

 

My problem is that Remove Duplicates in query editor does not recognize them as duplicates (Wich is OK for me) but Relationship Manager sees them as duplicates and does not allow me to create the relationship.

 

Do you now of any workarrround to this?