2 Replies Latest reply on Nov 6, 2018 9:11 AM by jon syu

# Mapping - IPv6 Address - Geocode Data

So I'm using the IP2Location database, and I managed to join the IPv4 addresses using this:

I've been trying for days to do the same with the IPv6 addresses but I can't figure it out.  Took a couple of more days scouring google too, but no luck.  So if anyone's figured out how to do this, please, please please please, help me out.  Will be eternally grateful and will also psychically remote bless you.

• ###### 1. Re: Mapping - IPv6 Address - Geocode Data

Here's another question that should've been asked first:  is this possible?  I mean does tableau have problems with numbers that large?  If so, what's another way to approach this problem?

1 of 1 people found this helpful
• ###### 2. Re: Mapping - IPv6 Address - Geocode Data

here's the basic idea:

2600:2342:EB25:52::FFF

split it into 8 different hexidecimal numbers = 2600 , 2342 , EB25, 0052, 0000, 0000, 0000, 0FFF

=(1)+(2)+(3)+(4)+(5)+(6)+(7)+(8)

translate each number into base 10, by applying this to each digit of the number:
(x[1 of the 8 numbers])=(a+b+c+d[each digit])=a*16^3+b*16^2+c*16^1+d*16^0

a*4096+b*256+c*16+d*1=(x)

(1)=2*4096+6*256

=8192+1536

=9728

… (2)-(7) …

(8)=15*256+15*16+15*1
=3840+240+15
=4095

do that for each of the numbers, then add them all together:  (i'm too lazy to type it all out, but i checked, this works)

=x1+x2+x3+x4+x5+x6+x7+x8

=a huge number

1 of 1 people found this helpful