Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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. |
Excellent Laxminarayana,
Regards
Kindly mark as correct answer so that people can make use of that
Thanks