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

    Mapping - IPv6 Address - Geocode Data

    Jon Syu

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

       

      https://kb.tableau.com/articles/howto/mapping-ip-address-geocode-data

       

      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
          Jon Syu

          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
            jon syu

            here's the basic idea:

             

            let's say this is your IPv6 address:

             

            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