http://forums.visokio.com/discussions/tagged/data-mapping/feed.rss Mon, 30 Oct 17 12:14:46 -0400 Tagged with data-mapping - Visokio Forums en-CA http://forums.visokio.com/discussion/3260/search-and-replace-large-amount-of-data Mon, 31 Jul 2017 09:39:04 -0400 CarenaLi 3260@/discussions I am trying to do search and replace in my data,
e.g. in my data it shows "yt", then I need to replace it as "YouTube".

I have an Excel file of all short codes and their full names.
Is there any quicker way to do so?
Many thanks!
Carena]]> http://forums.visokio.com/discussion/2652/data-mapping-add-formula-getting-very-slow-with-many-lines Tue, 22 Jul 2014 11:26:13 -0400 daniel 2652@/discussions
Could this be looked at to see if whether there's a way to optimize it? I'm finding I am adding more and more lines to the IF function and it will get more unstable.

I think it's slow because it tries to apply the function as I try to rewrite it and keeps processing them in the background, perhaps there's a way to stop the processing part until I finish writing in the full set of IF functions?]]> http://forums.visokio.com/discussion/2365/data-mapping-using-merge-operation-to-assign-value-de-duplicate-variations-of-the-same-term Fri, 04 Oct 2013 11:30:05 -0400 paola 2365@/discussions 2 fields are corrected ([Provider LName] and [Address]), using two mapping lists with unique values, and Merge operation with multiple merge criteria, ensuring correct association is made, therefore avoiding many:many matches or incorrect association.

Following formula in the FieldOrganiser helps populate empty fields with the single value, for the given combination of 3 fields, where field [Provider Tax ID] is only partially populated.
SUBSET_FIRSTNONNULL([Provider Tax ID],
SUBSET3([Provider Fname], [LnameCorrected], [AddressCorrected]))]]>