VerityDotNet 1.0
C# library for Verity data profiling, quality control, remediation
Class List
Here are the classes, structs, unions and interfaces with brief descriptions:
[detail level 123]
 NVerityDotNet
 CAnalyzeQualityPerforms deep inspection of data records to discover and assess a variety of structure, syntax, and semantic problems and inconsistencies
 CCoValueCoValue object to define 2 or 3 fields for joint value analysis
 CDateFuncsVarious functions to manipulate datetime
 CExecTransformExecutes transforms as chain. All final results are returned as string
 CFieldField object with properties for title, datatype, formatting
 CLicenseMgrManages VerityDotNet license
 CLookupLookup dictionary object for transform processing. Transforms have an operation (Op) that allows assigning a value based on looking up the current value in a dictionary. 1, 2, 3 keys are allowed with the replacement value coming from the following column. This Op is in transform_types for category=assignment, function=lookup. The description of this function and how it uses the lookup is:
 CLookUpDictDictionary with keys (either 1,2,3 field values) mapped to replacement value. The keys can use wild cards and also special notations for AND and NOT conditions
 CLookUpRecRecord within a lookup dictionary
 CNumFuncsHelper function to manipulate numbers
 COpTypesTypes for transform operation objects.Each operation category(OpCat) has one or more functions each of which is defined by an OpFunc object. Method SetUpCats is a convenience method to make list of OpCat objects, each of which defines a category of transform operations(Ops), and contains a child list of OpFunc objects
 COpCatCategory definition for grouping transform operations. This is intended to be used for the specification of available transform operations. Categories are: assignment, conditional, numeric, text, date. title: name of category
 COpFuncFunction definition for defining transform operations. This is intended to be used for the specification of available transform operations. Operation functions may have 0-3 parameters (params) supplied. Their use depends on the specific function. title: name of function such as ifEq or setToValue
 CQualityAnalysisObject containing settings and results of quality inspection
 CRecFuncsHelper functions to split quoted data records, handle parameter aliases, detect datatypes, and others. char_aliases are tokens to allow specifying disruptive characters. For example, -lsquare- is the [ character which has special meaning in code
 CRefineDataRefine data record into new output record doing datatyping, formatting, transforms, and error remediation
 CRefineryObjectsContainer for objects needed during Refine methods
 CRemediateParsingRemediates (i.e fixes) records that parse incorrectly leading to incorrect number of field values relative to number fields in schema. This has three types: big: too many field values typically due to embedded delimiters in some field values small1: too few fields by 1 which can either be an error or acceptable since some databases intentionally drop last field if it is empty setting it as null small2: too few fields by 2 or more typically caused by line feeds in fields or problems exporting records across data system types This class detects and corrects these errors making new records that are correct
 CReportFuncsUtility report functions
 CTransformTransform object for modifying source field values and generating values for added enrichment fields. A transform contains a sequence of operations that may include conditional testing of values and referenced fields. It operates on the field whose name is the title of the transform. This field should always be the output field title which itself can be a source field, a renamed source field, or an added enrichment field. Processing check output field list first and if a match is not found then checks the 'mapto' property of output fields for a match to an original source field title
 COpOperation (Op) for transforms. Each Op has a title which is the name of the function. It specifies the function and its category along with several possible parameters(Param1, Param2, Param3) that depend on the specific function
 CTransformFuncsMethods for managing Transforms