Data Integration

[Anonymous]

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.

[mayuresh_d]

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 .

ty

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

Excellent Laxminarayana,

Regards

[Anonymous]

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

Thanks