Join using Floating key

xavier

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
 

Support

Administrator
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').
 
Top