DLANormalizeDataTable

Class for normalizing a datatable imported from an excel sheet

Package TEA
Author Bert Dingemans
Alias --
Stereotypes --

Attributes

Name Type Cardinality Description
_DataTable DataTable 1 - 1--
_ResultDT DataTable 1 - 1--
Percentage Int32 1 - 1--
Optimize Boolean 1 - 1--
Repository EA.Repository 1 - 1--
oRoot EA.Element 1 - 1--
RootFieldNames List(Of String) 1 - 1--

Methods

Name Type Description
GetRepositoryConnector DLAFormfactory.DataSet2RepositoryGet a connection to the active repository for further processing of the normalizer

@returns
CreateRootAttributes --Create the attributes in the root element (the startup object element for the normalizer)

@returns
CreateRootElement BooleanCreate a root class element (mostly based on the excel sheet name in the normalizer

@returns
CreateFieldCombinations BooleanCreate a normalized table in the repository based on the normalization results

@returns
CreateEnumerations BooleanCreate an enumeration in the repository based on the generated result set of the normalizer

@returns
EvaluateEnumeration BooleanEvaluate if a field is an enumeration

@returns
FieldsToString StringTransform a list of fieldnames to a comma separated text string

@returns
EvaluateCombination BooleanEvaluate if a combination of fields is a normalization combination

@returns
EvaluateDataTable DataTableProcess the fieldnames for enumarations and various fieldcombinations for normalization

@returns
CheckExist BooleanCheck weather a list of fieldnames exists in the normalization definities

@returns
AddResult --Add a row to the result datatable with a suggestion for a normalization/enumeration
New --Create a result datatable for doing a proposal for normalization and lookup definitions
DataTable DataTableconnection to the datatable

@returns

Diagrams

Linked elements