我有一栏person_ code的数据集。
I have a dataset with a column "person_code".
这列包含以下数据:
在卡拉 在卡拉 - >一个尾随空格现在,如果我设置数据集的列的主键person_ code我会得到以下错误:
Now if i set the primary key of the dataset to the column "person_code" I'll get the following error:
这些列当前没有唯一值。
"These columns don't currently have unique values."
解决这个办法?最好我能想到的是添加一个新栏目primary_key,然后更换结束/开始另一个标志位。这将导致一些额外的问题:如果我代替他们_而且也已经是Carra_数据库...
Any way around this? The best I can think of is to add a new column "primary_key" and then replace the ending/starting spaces with another sign. This will cause some extra problems: if I replace them with _ and there's already a Carra_ in the database...
有没有更好的办法?
推荐答案
主键始终是唯一的,所以如果两个人有相同的人code,那么这确实会导致此问题
Primary keys are ALWAYS unique, so if two person have the same person code then this will indeed cause this problem
现在,他们似乎并不完全一致(就像你说的人有一个尾随的空间。我的猜测是,你的code可能会删除默认的尾部空间,你可能想要把一个符号在开始并在结束时,像卡拉和卡拉,使他们不同的。
Now, it seems that they are not entirely identical (as you say one has a trailing space. My guess is that your code may remove the trailing space by default. You might want to put a symbol at the start and at the end, like 'Carra' and 'Carra ' to make them different.
您可能需要尽管定义另一个symbole了这一点。尝试一个你知道的永远不会在你的数据。
You may need to define another symbole that that though. Try one that you know will never be in your data.
相关推荐
最新文章