Tagged with de-duplication - Visokio Forums http://forums.visokio.com/discussions/tagged/de-duplication/feed.rss Mon, 30 Oct 17 15:59:24 -0400 Tagged with de-duplication - Visokio Forums en-CA Refresh: Both Appending and Updating? http://forums.visokio.com/discussion/2542/refresh-both-appending-and-updatings Wed, 30 Apr 2014 12:44:57 -0400 nuriozlu 2542@/discussions
I would like to make a request ...my case;

We have two kind of data in some of our tables
1-newly added rows ( new bookings with new booking ID )
2-updated fields in older rows ( old bookings with some updated fields)

However, whenever we want to update the report it would be very nice to have an option of both updating the related fields of the previous rows and appending the newcomer rows at the same time.

When I use the append table function, the old ones will be duplicated or when i use the update function new rows will not be added?

It would be very helpful for us
Kind regards]]>
Idea: Fuzzy matching in De-duplicate? http://forums.visokio.com/discussion/2063/idea-fuzzy-matching-in-de-duplicates Tue, 19 Mar 2013 09:23:29 -0400 grahamb 2063@/discussions http://www.tech4t.co.uk/pages/t4t-doubletake-2.html]]> Idea: DataManager - Remove fields in Deduplicate block? http://forums.visokio.com/discussion/1706/idea-datamanager-remove-fields-in-deduplicate-blocks Wed, 15 Aug 2012 09:22:54 -0400 Mees 1706@/discussions
Thanks - A]]>
Integration: Merge/Join on first match only? http://forums.visokio.com/discussion/2439/integration-mergejoin-on-first-match-onlys Tue, 14 Jan 2014 06:43:23 -0500 martins2 2439@/discussions
Here is what I'm trying to do. I have a field containing a string of text which sometimes contains place names. I wish to match up the place names in this text string with the list of place names in the lookup data built in the data sources. Because it's a string of text I'm using the "contains" criteria in the merge/join block but this means that manchester and chesterfield will match chester. There are many other instances of this happening, too many to sort out manually.

If I sorted the data so that place names which contained other place names were at the top, and then I could merge the first match then I think this would solve this problem. Is this a possibility for future releases?

In the mean time can anyone think of a way round this?

Thanks, Martin]]>