topic Re: Data Integration in QlikView

Data Integration

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone, Any one having any idea on this case: I have a field with I.P addresses and if i want to get to know to which region or country that I.P address belongs to and create a Region field in my application , so that end users can know the region to which the I.P address belongs to.

Thanks in Advance.

Re: Data Integration

mayuresh_d — Wed, 06 Dec 2017 09:53:33 GMT

you can bring region field at backend ,qlikview can show data and operate data which we already have, can't bring data which we don't have, so you need to bring region or country field in front of ip address from other source and show at front end .

Re: Data Integration

Anonymous — Thu, 07 Dec 2017 10:37:27 GMT

Thanks Mayuresh, i do not have the Region or country field, i was interested to know if there is any technique to identify the I.P address and relate that IP address to the country or region and then i can load the region data into QV....Any ways thank you very much for the response.

Re: Data Integration

Anonymous — Thu, 07 Dec 2017 10:46:33 GMT

Name	Type	Description
ip_from	INT (10)† / DECIMAL (39,0)††	First IP address in netblock.
ip_to	INT (10)† / DECIMAL (39,0)††	Last IP address in netblock.
country_code	CHAR(2)	Two-character country code based on ISO 3166.
country_name	VARCHAR(64)	Country name based on ISO 3166.
region_name	VARCHAR(128)	Region or state name.
city_name	VARCHAR(128)	City name.

Re: Data Integration

Anonymous — Thu, 07 Dec 2017 10:50:32 GMT

https://lite.ip2location.com/database/ip-country-region-city

Re: Data Integration

Anonymous — Thu, 07 Dec 2017 11:19:03 GMT

Excellent Laxminarayana,

Regards

Re: Data Integration

Anonymous — Thu, 07 Dec 2017 11:36:03 GMT

Kindly mark as correct answer so that people can make use of that

Thanks