A dataset contains rules to generate attributes (columns) of tables (datasets)
1 |
A dataframe with following variables
Table (Dataset) Name for the result. Result is returned as list of dataframes, list names conform to Table values from rules.
Attribute (Column) Name for generated result
Maximum length of attribute; mandatory for Number and optional fore Varchar
Maximum number of digits in decimal part of number; mandatry for Number
Data Type of attribute; can be Number
, Date
or Varchar
.
Date attributes must be in specific format "YYYYMMDD"
Defines order in which attributes are being generated. Attributes without
sequence receive Sequence = 0. In case Evaluation.Condition
or
Evaluation.Expression
refer to other attributes it is important
to define correct sequence.
Expresstion that returns either FALSE
or TRUE
; empty
condition is treated as truth.
Defines the way how value is being generated. Can be of following values:
Empty
(Empty value);
Fixed
(Fixed value, the same for all records of dataset);
Expression
(Calculated value based on formula);
Random
(Randomly generated value);
LOV
(Value picked from list of values).
Defines fixed value for Fixed
value type or offset for
Random
value type, offset is being added to random value.
Name of list with values. List of values must be existing one for successful value generation
Name of random distribution; must be specified for attributes with
Value.Type
= Random
Random distribution mean; must be specified for attributes with
Value.Type
= Random
Random distribution standard deviation; must be specified for attributes with
Value.Type
= Random
Sign Type for randomly generated value; must be specified for attributes with
Value.Type
= Random
. Sometimes it is important to have
values of only specific sign. Possible values are:
Any
(keep avlue as it is);
Not Negative
(replace negative values with 0);
Not Positive
(replace positive values with 0);
Flip Negative
(replace negative values with positive counterparts);
Flip Positive
(replace positive values with negative counterparts);
Expression that returns value; must be specified for attributes with
Value.Type
= Expression
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.