Tagged with data-mapping - Visokio Forums
http://forums.visokio.com/discussions/tagged/data-mapping/feed.rss
Mon, 30 Oct 17 12:14:46 -0400Tagged with data-mapping - Visokio Forumsen-CASearch and Replace: Large Amount of Data
http://forums.visokio.com/discussion/3260/search-and-replace-large-amount-of-data
Mon, 31 Jul 2017 09:39:04 -0400CarenaLi3260@/discussionsI 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]]>Data Mapping: Add Formula getting very slow with many lines
http://forums.visokio.com/discussion/2652/data-mapping-add-formula-getting-very-slow-with-many-lines
Tue, 22 Jul 2014 11:26:13 -0400daniel2652@/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?]]>Data Mapping: using Merge operation to assign value - de-duplicate variations of the same term
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 -0400paola2365@/discussions2 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]))]]>