Join using Floating key


New member
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
xavier forum 1.png

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

xavier forum 2.png


Staff member
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').