Hi, we are loading a table from our source data base. A column which is part of the key, contains values that are similar but not the same. The difference is in a trailing space. Now, when TimeXtender reads this dataset, it claims a violation of uniqueness. The column is set to be VARCHAR(), which probably causes the system to trim the trailing space, resulting in a duplicate value.
As the source system recognizes this as different entries, we want to keep both. How to solve this?
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/5bc7d280-798f-4e48-97b9-53f9eaef4eda.png)