For maximum efficiency, your Tables should follow these basic rules:
- The first row must contain your field headers (or column names). Make sure NONE of your column headers begin with a blank space.
- The first row must be the only row of headers.
- Preferably, starting on the second row, the first column should contain the row identifiers (record names).
- Avoid blank rows and blank columns.
iugum Data Software is a generic application that can match any type of data. You can customize iugum Data Software by adding elements to the three libraries—noise, predefined and synonyms—with the Match Toolbar. Accumulating relevant matching information in these libraries increases the accuracy and speed of the matching process. The more you use iugum Data Software the more powerful it becomes.
How do I control the level of similarity required for iugum Data Software to suggest a possible match?
Before launching a match session you can set the “Min. similarity %” to a value below or above the default value of 80%. Depending on the set of data you are using, you will want to set this parameter to a higher (lower) value to increase (decrease) the degree of similitude necessary for iDS to suggest possible matches.
New information can be added to the libraries, except to the iDS.Generic library. To add new information to the libraries, you can either go to Library/Manage or use the Match Toolbar in step 5. Any library, including the iDS.Generic library, can be copied to create a new user library. You can also export or merge libraries with a simple right-click on their names.
You can use wildcards such as “?” or “*” to increase the flexibility and efficiency of your Noise lists. The wildcard “?” will match any single alphabetic character in its position, while “*” will match any number of characters in its position. Both wildcards can be used as the first or last character of a Noise word. For instance, ENTERPRISE? covers “enterprise” and “enterprises” and INCORPOR* covers “incorporation” , “incorporated”, “incorporating” and so on.
There is no limit per say, but larger files will take longer to match. It also depends on the type of match and the libraries you are using to emphasize speed or more precise matches. Read more about this here: The Dashboard Panel.
Yes. iugum Data Software identifies unmatched items within the “None” category. This can be useful in many instances, including finding missing observations in a time series.
To convert a date to text in Excel, use the following formula (assuming your date is placed in cell A1):