http://forums.visokio.com/discussions/tagged/lookup/feed.rss Mon, 30 Oct 17 18:56:19 -0400 Tagged with lookup - Visokio Forums en-CA http://forums.visokio.com/discussion/1421/idea-standardise-values-blocks Mon, 26 Mar 2012 04:13:06 -0400 daniel 1421@/discussions
I do have one more suggestion though is that the match up would allow for Many to One scenarios as I have encountered examples where an area name match up would be many to one as a number of areas merged into a single area i.e:


Old Name of Areas :Chester-le-Street, Derwentside, Durham, Easington, Sedgefield, Teesdale, Wear Valley

Which are all now grouped up as just County Durham due to UK parliamentary boundary changes. On the whole the UK has been shrinking the number of areas so often you may get an outdated list with "extra" areas names than the current UK parliament boundaries list.


Original comment taken from a different thread:

This is quite a common problem, but not one which the merge/join block should attempt to solve. Fuzzy matching won't help here. For example, some common value mismatches, most of which you can't solve with fuzzy matching:

- US, USA, United States, US of A, America
- Cardiff, Caerdydd, Cardiff/Caerdydd
- Russia, Russian Federation
- London, Londres
- GB, UK, United Kingdom, Britain, Great Britain, British Isles
etc.

Currently you have to use a Search/Replace block to manage these, which is very tedious to configure. You can use merge/join to identify unique mismatches, then auto-generate a Search/Replace configuration based on those mismatches, but you are still going to have to manually locate each right-side value for each missing left-side value.

A possible solution is a new kind of block, "Standardise values". It would have two inputs: (1) the main data (2) the lookup file. You would pick a field from each side, much as you do in merge/join. It would then enumerate all unique values from left that are missing from right, with searchable drop-downs to pick the correct mapping. It would result in the main data from the left, with all values standardised according to the right file. ]]> http://forums.visokio.com/discussion/1019/facebook-location-lookup Wed, 28 Sep 2011 17:55:54 -0400 hgross 1019@/discussions http://forums.visokio.com/discussion/715/ip-address-lookup Wed, 20 Apr 2011 07:39:12 -0400 sherriff 715@/discussions Can you please suggest the most efficient way to do this.
So far I have researched two possible methods but am unable to complete either one due to lack of knowledge in how to implement:
1) API for web lookup: http://ipinfodb.com/ip_location_api.php
2) Import a large IP address database into Omniscope (see file attached) this requires conversion of IP address format into Integer number and then some clever lookup which I am unable to figure out.]]>