IDEA & WPP Community
Home
Search
Keywords
Advanced search
Startpages
Download sourcecode
What is IDEA?
About the WPP
All startpages
Overview
Packages
Diagrams
Extra
Explorer
Matrix
Release notes
Glossary
Charts
Participant
Participate
Login
Contact
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.DataSet2Repository
Get 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
Boolean
Create a root class element (mostly based on the excel sheet name in the normalizer
@returns
CreateFieldCombinations
Boolean
Create a normalized table in the repository based on the normalization results
@returns
CreateEnumerations
Boolean
Create an enumeration in the repository based on the generated result set of the normalizer
@returns
EvaluateEnumeration
Boolean
Evaluate if a field is an enumeration
@returns
FieldsToString
String
Transform a list of fieldnames to a comma separated text string
@returns
EvaluateCombination
Boolean
Evaluate if a combination of fields is a normalization combination
@returns
EvaluateDataTable
DataTable
Process the fieldnames for enumarations and various fieldcombinations for normalization
@returns
CheckExist
Boolean
Check 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
DataTable
connection to the datatable
@returns
Diagrams
TEA
--
Linked elements
TEA
FrmImportExcel