Join using Floating key

[xavier]

I have two sources, I make a link on a field Document ID and CATALOGKEY (which are unique keys)

In the .gel the catalogkey is linked to a Numext number

But when we make the link based on the Document ID and CATALOGKEY, This same catalogkey does not refer to the same number.

 

[Support]

Hi Xavier,
The column "CATALOGKEY" is too big to be manipulated as a number (there are more than 14 digits: we are beyond the accuracy of the machine on floating point numbers (the "double")): you have to manipulate it like a String: ie: Make alpha-numeric sort ('A') and not numeric ('0')
The join should work correctly after alpha-numeric sorting ('A').