DSXchange

Ray,

Are you using INTEGRITY 6.x or QualityStage?

Tim

Integrity works as well if not better at free-form data investigation, standardization and matching as its competitors. However, realize that you must write and create custom rules no matter what tool you are using. Depending on the complexities of your data, extracting value from it can sometimes b...

Hello World, What people using out their as their Master Lists for Customer and Vendors (Companies, not individuals). In Integrity, you have the Investigation and Standardization, which is essential preping the data for the matching process (probabalistic matching). My question is how do most folks ...

You can absolutely install MetaRecon on a laptop. I've installed it on 3 different laptops running Windows XP. You have to follow the installation instructions in EXACT order. You must also have a data repository, which has to be installed prior to the MetaRecon install. An ODBC connection has to be...

Is there a place where Integrity's Error Codes and Error Messages are documented?

I'm having a problem de-bugging my code. Specifically, I need to furthur understand what the error code is trying to tell me. I only know the line that is causing the error!

Tim

I find Quality Manager to be a bit quirky. What are the data types for the fields that keep disappearing? Sometimes quality manager does not like to recognize Varchar(255) text fields. Do you have access to MetaRecon (ProfileStage). I find that it is much better to work with, especially for profilin...

Ray, That's actually what I had to do. Integrity (QualityStage) assumes a "wild card" at the end of the pattern you define. Therefore, my pattern file goes in this exact order: N|N|N|N|N N|N|N|N N|N|N N|N N You don't have add the wild card, which would have looked like: N|N|N|N|** N|N|N|**...

Raviyn, To my knowledge, no DQ product or cleansing product allows you to automatically standardize to UNSPSC codes, or to automatically standardize products, parts, items, or material descriptions. NO ONE HAS THIS PRE-BUILT! However, Integrity give you an excellent platform to develop your own stan...

In the Patten Match File, how do I get Integrity just to look for an exact match on the string that I am indicating. Example: I have a specific rule for +NNN In the pattern match file, the order of my rules are: +|N +|N|N +|N|N|N I found out that that standardization file never got to my rules for +...

The input data must be in the exact order:
City, State, Zip Code, Country.

Then it works fine.

Here was my personal fix: First: Standard everything prior to the "C". Second: Have a second sub routine or procedure that runs the following: C | ** COPY_A [1] CNTemp CONCAT " " CNTemp COPY_S [2] CNTemp CONCAT CSTemp CNTemp COPY CNTemp {CN} RETYPE [1] 0 RETYPE [2] 0 RETYPE [3] 0...

Does anyone have experience with Subfield Ranges. I'm trying to write some standardizations for company names. I'm trying to make a more dynamic call for using code (a subroutine), that I already created in the Pattern Match file, for a slight variation of the same pattern. Example: Pattern A: ++A (...

I am passing US City, State, Country and Zip code data to Integrity. Within Integrity I am using the SuperStan procedure to Standardize the Area data to conform to Integrities standard output. Integrity handles City, State and Country very well. Unfortunately, it is sending all the Zip code data to ...