This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We just got Alteryx and are loving it. I'm trying to geocode the IP address in my dataset using this free IP address database here: https://lite.ip2location.com/database/ip-country-region-city-latitude-longitude-zipcode-timezone
Prior to Alteryx, I would have easily done this in Tableau 2018.1 based on this Tableau knowledge base info here: https://kb.tableau.com/articles/howto/mapping-ip-address-geocode-data
and also in the attached Tableau file.
I am now wondering if this is possible in Alteryx? Can we actually geocode IP addresses in Alteryx
Is it possible to do a join based on a range i.e. >= or <= in Alteryx similar like in Tableau? Does Alteryx join only with the equality sign?
I would so much appreciate your help on this.
Thank you very much!
Hello Alteryx community,
I am updating this post with clearer details on how Tableau converts the IP addresses in my dataset to numeric format and then joins that using the IP address range.
IP START RANGE left join formula.
LEFT([IP Address],(FIND([IP Address], ".")))
FIND(MID([IP Address],FIND([IP Address],".")+1),".")-1)
FIND([IP Address], ".", FIND([IP Address], ".") +1)+1,
(FIND([IP Address], ".", FIND([IP Address], ".", FIND([IP Address],"." ) +1) +1)) - (FIND([IP Address], ".", FIND([IP Address], ".") +1))-1
LEN([IP Address]) -
FIND([IP Address], ".", FIND([IP Address], ".", FIND([IP Address],"." ) +1) +1)
IP END RANGE
I would so much appreciate if you can help me figure out how to do this in Alteryx.
This works ok in Tableau when the dataset is small. However, with increased dataset, it's taking FOREVER to create the tableau extract.
If I can do this in Alteryx and create the extract in Alteryx that will be fantastic!
Looking forward to hearing from you.
Thanks a million in advance for your help ,