Excel unique value not anymore unique on Lumira

[Former Member]

53960 unique values end up 53571 unique values in Lumira right after Excel import.

Then eventually when I'd like to use this column as unique key before merging with another Excel file I ran into this: the selected lookup columns do not const a unique key.

Any thoughts?

[TammyPowlas]

Wouldn't it be easier then to use the Remove Duplicates ribbon in Excel before bringing it into Lumira?

[Former Member]

Yes, it would be. And we tried this hours ago.

The problem is Lumira does not take unique values as unique somehow.

[TammyPowlas]

Are you saying Lumira takes the data which is unique in Excel and then it is no longer unique?  If that is the case I recommend opening an incident with SAP Support.

[achab]

Can you use the "export dataset as Excel" function of Lumira to compare your initial dataset to the exported one? This may help understand what happens.

Thanks

Antoine