2 Replies Latest reply on Nov 8, 2018 5:15 AM by Jon Syu

# Some Questions on Join Calculations (Big Numbers, Complex Calculations, Etc.)

A few random questions on join calculations:

1)  this first one is actually about tableau in general--are there limits on integer sizes?  floats?  this number for example:

42541956123769884636017138956568135816

2)  say i have join calculations that match up values from table A to one of two categories in table B.  what can i do to make the join calculation run faster--like do some functions/data types/calculations/etc. run more efficiently during calculations?  maybe there's a list of this somewhere...

3)  i'm working on a really long (at least for me) join calculation.  usually it'd be a lot easier to refer to other calculations or variables or something, but they don't seem to be available for join calculations.  any tips for dealing with this?

4)  on a somewhat related note, in terms of worksheet speed, does it matter when you join data and make extracts?  example:  is there any difference in terms of worksheet speed between running off an extract created from two datasources, versus an extract made from two extracts of the two datasources?

All tips, suggestions, sources are welcome and appreciated, thanks!

• ###### 1. Re: Some Questions on Join Calculations (Big Numbers, Complex Calculations, Etc.)

Hi,

I want to answer number 1.

For data types in programming, the largest data type would be 8 bytes for an integer +/-

-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

and that sample long value you want will not show as it is (if calculated as numerical value)

but only truncated to the memory size allowed and or

converted to exponential format similarly will be done in Tableau Desktop and applications

Regards,

Bryan

1 of 1 people found this helpful
• ###### 2. Re: Some Questions on Join Calculations (Big Numbers, Complex Calculations, Etc.)

I'm on tableau desktop.  I need the exact number because I'm going to use it to match values in another table with a join calculation.  Is there anyway around this?