Calculations with Field Type Int64

mathias_schnoor

Hey!

When I worked with large number from my postgres table than the greates bigint (int 64 too) is 8999999999999999999

for numbers greater as bigint I can use type numeric.

When I make a Int64 field with the value 8999999999999999999 Alteryx returned 9000000000000000000

Other example:

Postgres binint value 1234567891012345678

Alteryx returned the Int64 value 1234567891012345600

what is the matter?

Exists a Type like postgres numeric in Alteryx?

Mathias

s_pichaipillai

@mathias_schnoor

i don't have postgres table for testing 

but when i tested with your values it did return correct value.

can you convert to string then use select tool then convertback to INT64.

what version of alteryx are you using ?

Bigint.yxmd