Programming Entities

On this page, you will find information about common entities, including property names and usage information. Click here to show all details. Also, see Recipes and messages. Below is a list of property markers:

	Calculated	Calculated properties are automatically set by the system, and cannot be changed using update requests.
	Set once	Set once properties can be set by the user upon entity creation, but cannot subsequently be changed (only read).
	Filtered	Filtered properties are removed or filtered because they contain confidential information (searches referencing them are also blocked).

WorkspaceInfo

Represents a secure container encapsulating other entities.
Actions: Retrieve, Create, Update, Delete.
Click here to view properties.

DatabaseInfoId (Guid ):
ID of the database in which the workspace is stored
OwningUserInfoId (Guid ):
ID of the user owning the workspace
CreatedBy (String ):
Name of the user who created the workspace
Name (String):
Name of the workspace
Description (String):
Description of the workspace
Id (Guid ):
ID of the workspace
DateCreated (Date ):
Date the workspace was created

Click here to view usage notes.

Many entities have a workspace ID property which controls under which workspace they live.
Access to a workspace is controlled by rights, including the right level.
For more information about managing rights, click here.

UserInfo

Represents a user account.
Actions: Retrieve, Register, Update.
Click here to view properties.

FirstName (String ):
First name associated with the user account
LastName (String ):
Last name associated with the user account
EmailAddress (String ):
E-mail address associated with the user account
Name (String ):
Log in name associated with the user account
Password (String ):
Password associated with the user account
DisableCompression (Boolean ):
Whether the Web client should try compressing sent XML requests
DisableCaching (Boolean ):
Whether the Web client should try caching locally frequently accessed data
LicenseKey (String ):
License key associated with the user
RegistrationCode (String ):
Registration code used to confirm the account via e-mail address registration
PasswordResets (Integer ):
Number of password resets effected so far
RegistrationConfirmations (Integer ):
Number of registration confirmations effected so far
Disabled (Boolean ):
Whether the account has been disabled
Id (Guid ):
ID of the user account
DateCreated (Date ):
Date the user account was created

Click here to view usage notes.

You cannot register multiple user accounts sharing the same account name or e-mail address.
To protect confidentiality, some properties are filtered when the caller is not the owner of the account (ex: first name, last name, e-mail address, etc.).
To ensure security, some properties are always filtered when retrieved, regardless of the caller (ex: registration code, password, etc.).
A user's license key can be replaced by another (typically more permissive) one, but never removed.
To change account settings, the update request must carry a ticket representing the user associated with the account.
If a user was disabled by the system, authentication for this user will fail (this setting cannot be changed).
For more information about registering users, click here.

RightInfo

Represents a right granted to a user on a workspace.
Actions: Retrieve, Create, Update, Delete.
Click here to view properties.

CreatedBy (String ):
Name of the user who created the right
WorkspaceInfoId (Guid ):
ID of the workspace to which the right is granted
UserInfoId (Guid ):
ID of the user to which the right is granted
RightLevel (Enum):
Access level granted
ApprovalLevel (Enum):
Current approval level
Id (Guid ):
ID of the right
DateCreated (Date ):
Date the right was created

Click here to view usage notes.

You must have manage permission on a workspace to create (grant) new rights for the workspace.
At any given time, at most one right for each user & workspace combination can exist.
If no right exists for a given user and workspace, the user has no right whatsoever on the workspace.
Workspace owners cannot delete their own rights because this may leave the workspace without any owner.
Callers cannot upgrade or downgrade their own right level (another user with manage permission should do this).
When a new right is granted, its approval level is set to pending (recipients must update the right and set it to approved to accept, or delete the right to decline).
For more information about managing rights, click here.

TableInfo

Represents a table containing either uploaded data, tasks, or task results.
Actions: Retrieve, Update, Delete.
Click here to view properties.

CreatedBy (String ):
Name of the user who created the table
DatabaseInfoId (Guid ):
ID of the database in which the table is stored
WorkspaceInfoId (Guid ):
ID of the workspace encapsulating the table
OwningUserInfoId (Guid ):
ID of the user owning the table
TableType (Enum ):
Table type.
AssociatedTypeName (String ):
Name of an entity whose instances are stored in the table (not applicable to data tables)
Ready (Boolean ):
Whether the table is ready because all pending uploaded data chunks have been imported (only applicable to data tables)
RowsTruncated (Boolean ):
Whether some imported rows were truncated, due to license restrictions
ColumnsTruncated (Boolean ):
Whether some imported fields (columns) were truncated, due to license restrictions
Name (String ):
Name of the table
Description (String):
Description of the table
Id (Guid ):
ID of the table
DateCreated (Date ):
Date the table was created

Click here to view usage notes.

Tables are automatically created when uploading new data, and cannot be created using normal create message requests.
Data tables contain data sets uploaded by users, while other types of tables may contain tasks, task results, etc.
Tables names are SQL names which are automatically generated and cannot be set (however the description can be set).
For more information about uploading data, click here.
For more information about executing tasks, click here.

FieldInfo

Represents a field (column) within a data table.
Actions: Retrieve.
Click here to view properties.

TableInfoId (Guid ):
ID of the data table associated with the field
Name (String ):
Name of the field
Description (String ):
Description of the field
FieldType (Enum ):
Field type
FieldPurpose (Enum ):
Field purpose
IsSystem (Boolean ):
Whether the field was not present in uploaded data, but added for tracking purposes (ex: system field to identify each row using a unique ID)
TotalCount (Integer ):
Total number of rows
NotNullCount (Integer ):
Total number of rows for which the field is not null / missing
DistinctCount (Integer ):
Total number of rows for which the field has distinct values
Avg (Double ):
Average value for the field (only applicable to numeric fields)
Std (Double ):
Standard deviation for the field (only applicable to numeric fields)
Min (Double ):
Min value for the field (only applicable to numeric fields)
Max (Double ):
Max value for the field (only applicable to numeric fields)
IsIndexed (Boolean ):
Whether the system decided to index the field
FieldOrder (Integer ):
Order in which the field appeared when data was imported (ex: first column = order 0)
DistributionStatXml (String ):
XML specifying the distribution of data (ex: top discrete values, distribution of numeric values)
Id (Guid ):
ID of the field

Click here to view usage notes.

Fields are automatically created when importing new data, and cannot be created using normal create message requests.
Field names are SQL names which are automatically generated and cannot be set.
Fields cannot be updated or deleted directly (delete the associated table).
For more information about uploading data, click here.

ChunkInfo

Represents a chunk of uploaded data used to create a new data table.
Actions: Retrieve, Create, Delete.
Click here to view properties.

CreatedBy (String ):
Name of the user who created the data chunk
WorkspaceInfoId (Guid ):
ID of the workspace encapsulating the data chunk
TableInfoId (Guid ):
ID of the data table to create when importing all data chunks
OwningUserInfoId (Guid ):
ID of the user owning the data chunk
FileName (String ):
Name of the file from which the data chunk was read
Content (String ):
Base64-encoded bytes from a CSV file
ChunkOrder (String ):
Order in which the data chunk appeared in the data file (ex: first chunk = order 0)
HasFieldHeader (Boolean ):
Whether the first line in the data file specifies field names (vs. contains the first row of data)
Id (Guid ):
ID of the data chunk
DateCreated (Date ):
Date the data chunk was created

Click here to view usage notes.

Do not forget to increment the chunk order as you read and upload more data chunks from a file.
Ensure you specify the same data table ID while uploading data chunks from the same file.
Ensure the specified data table ID does not already exist at upload time (it will be created later on by executing a data upload task).
Data chunks cannot be updated but can be deleted.
Data chunks which are created but not committed to a data table count against your license quota (commit or delete them).
For more information about uploading data, click here.

ImageInfo

Represents an image to display in the gallery.
Actions: retrieve, create, update, delete
Click here to view properties.

CreatedBy (String ):
Name of the user who created the image
WorkspaceInfoId (Guid ):
ID of the workspace encapsulating the image
OwningUserInfoId (Guid ):
ID of the user owning the image
ThumbnailContent (String ):
Base64-encoded image thumbnail content (in png format)
ImageContent (String ):
Base64-encoded image content (in png format)
XamlContent (String ):
Base64-encoded image content (in XAML format)
Keywords (String):
Column-separated list of keywords associated with the image
Size (Long ):
Size of the image (in bytes)
Width (Integer ):
Width of the image (in pixels)
Height (Integer ):
Height of the image (in pixels)
ThumbnailWidth (Integer ):
Width of the thumbnail image (in pixels)
ThumbnailHeight (Integer ):
Height of the thumbnail image (in pixels)
Rating (Double):
Average rating for the image (from 0 to 5), or new rating (see usage notes)
RatingCount (Integer):
Total number of ratings for the image
Name (String):
Name of the image
Description (String):
Description of the image
Id (Guid ):
ID of the image
DateCreated (Date ):
Date the image was created

Click here to view usage notes.

To create an image, you can specify XAML or png content, but not both.
If you specify XAML content, equivalent png content will be automatically generated and set.
Thumbnail content and image size information are automatically generated and set.
The rating specifies the average rating.
To rate the image, set the rating property and update the image: the average rating will be adjusted and updated.

CommentInfo

Represents a comment associated with an image or task results.
Actions: Retrieve, Create, Update, Delete.
Click here to view properties.

CreatedBy (String ):
Name of the user who created the comment
WorkspaceInfoId (Guid ):
ID of the workspace encapsulating the comment
OwnerId (Guid ):
ID of the entity with which the comment is associated (ex: image ID, task result ID)
OwningUserInfoId (Guid ):
ID of the user owning the comment
Tag (String):
Tag indicating which particular item of a task result the comment is associated with
Comment (String):
Textual comment
Color (Integer):
Color used to show the comment in the Web client
Id (Guid ):
ID of the comment
DateCreated (Date ):
Date the comment was created

Click here to view usage notes.

Comments are typically associated with images or task results.
For tasks, a tag can be used to indicate which particular item of a task result the comment should be associated with.
For example a tag may be used to indicate that a comment should be associated with a particular area of a tree map result.
To prevent abuse, comments can only be updated by their owners.

SettingInfo

Represents a setting used to persist any user preference.
Actions: Retrieve, Create, Update, Delete.
Click here to view properties.

CreatedBy (String ):
Name of the user who created the setting
WorkspaceInfoId (Guid ):
ID of the workspace encapsulating the setting
OwnerId (Guid ):
ID of the entity with which the setting is associated
OwningUserInfoId (Guid ):
ID of the user owning the setting
Name (String):
Name of the setting
Value (String):
Value of the setting
Id (Guid ):
ID of the setting
DateCreated (Date ):
Date the setting was created

Click here to view usage notes.

Settings can be used to persist any user preference using a name / value pair.
For example, the Web client persists information about how users arranged views using settings.
To prevent abuse, settings can only be updated by their owners.
To prevent abuse, a limited number of settings can be created per workspace and per user.

LogInfo

Represents a security log event.
Actions: Retrieve.
Click here to view properties.

WorkspaceInfoId (Guid ):
ID of the workspace encapsulating the log event
UserName (String ):
Name of the user who caused an event to be logged
Action (String ):
Name of the action performed
Target (String ):
Name of the entity on which the action was performed
Details (String ):
Additional details about the action performed
Id (Guid ):
ID of the log event
DateCreated (Date ):
Date the log event was created

Click here to view usage notes.

Log events are automatically created when actions are performed on a workspace.
Only users with manage permission on a workspace can retrieve corresponding log events.
Log events cannot be deleted or updated.

OrgLicenseInfo

Represents an organization license.
Actions: Retrieve, Create.
Click here to view properties.

LicenseKey (String ):
License key
Id (Guid ):
ID of the org license
DateCreated (Date ):
Date the org license was created

Click here to view usage notes.

Organization licenses can be added to unlock additional capabilities, but not updated or deleted.
For more information about licensing, click here.

RootDataUploadTaskInfo

Represents a data import task (imports data following data chunk upload).
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

LineSeparator (String ):
Separator to use to parse uploaded CSV data (applies only to CSV data, defaults to "," if unspecified)
CultureName (String ):
Culture to use to parse uploaded CSV data (applies only to CSV data, defaults to the neutral culture if unspecified)
FileType (String ):
File type (ex: ".csv", ".xls")
Context (String ):
Upload context (for Excel files: name of the data sheet to upload, required only when multiple ones exist)
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and into which data should be imported
TargetTableInfoId (Guid ):
ID of the (not yet created) data table for which data chunks have already been uploaded
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider (not applicable)
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data (not applicable)
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task is designed to import uploaded data, and does not produce any type of task result.
You can specify how uploaded content is formatted using properties LineSeparator and CultureName.
For example, US CSV files may contain dates in MM/DD/YY format, but a different format may be used by other locales.
For Excel files, you can specify the data sheet to upload using property Context (required only if the Excel file contains multiple data sheets).
Finally, the file type should be specified, or will be assumed to be ".csv".
For more information about uploading data, click here.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootDataTransformTaskInfo

Represents a data transformation task (transforms an existing table into a new one).
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

TargetTableDescription (String ):
Description to assign to the post-transform data table to create
SourceTableInfoId (Guid ):
ID of the existing data table to transform
TransformSequenceXml (String ):
XML specifying a sequence of transformation steps to execute
TransformEditSequenceXml (String ):
XML used by the Web client to keep track of editing state
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and into which a transformed data table should be created
TargetTableInfoId (Guid ):
ID of the post-transform data table to create
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider (not applicable)
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data (not applicable)
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task is designed to transform an existing data table so as to produce a new one.
You can simply copy an existing data set by setting property TransformSequenceXml to an empty string.
Or you can specify a sequence of transformation steps to execute by serializing a TransformSequence object.
Different types of available transformation steps are listed on this page.
For example, you can create, rename, delete, or convert fields.
For example, you can filter or sample rows.
For example, you can rank rows, scramble fields, or set fields to calculated formulas.
For more information about transforming data, click here.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootPivotTaskInfo

Represents a super pivot task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data (not applicable)
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task is used for data visualization, and does not produce any type of task result.
For more information about uploading data, click here.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootTimeSeriesTaskInfo

Represents a time series forecasting task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

TargetFieldInfoId (Guid ):
ID of the data field containing numeric values to forecast
SourceFieldInfoId (Guid ):
ID of the data field containing corresponding time series dates
Predictions (Integer ):
Number of values (at future time steps) to forecast
Simulations (Integer ):
Number of monte-carlo simulations executed so as to estimate the stability of the forecasting model
TrainingTime (Integer ):
Maximum execution time allowed (in milliseconds) when training the neural network on the time series
TrainingRounds (Integer ):
Maximum number of training rounds allowed when training the neural network on the time series
LearningRate (Double ):
Learning rate used by the neural network (typical values range from 0.1 to 0.9)
Error (Double ):
Specifies the average error obtained after training the neural network on the time series (measures how closely the model fits the time series)
LagCount (Integer ):
Number of past time intervals to consider when training the neural network on the time series (0 = autodetect)
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider (not applicable)
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data (not applicable)
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of TimeSeriesResultInfo records.
A neural network is trained on time series data to identify trends & patterns, and use this knowledge to forecast future values.
Once training is complete, the difference (error) between known past values and values predicted by the forecasting model is measured.
The distribution of errors is used to perform monte-carlo simulations, which help visualize the stability of the forecasting model.
For example, if the neural network was unable to build a forecasting model which closely fits the time series, errors will be high.
Accordingly, higher variations from predicted values should be expected.
The neural network learns how the previous N values (the lag) influence the following one.
The neural network is able to automatically detect the general periodicity of the time series.
The neural network automatically compensates for missing values or irregular time intervals.
The neural network stops training when lack of convergence is detected.
The neural network keeps track of the best model found during training.
The neural network uses a configuration designed to avoid overfitting the data and preserve generalization power.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootTreeMapTaskInfo

Represents a tree map task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data (not applicable)
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task is used for data visualization, and does not produce any type of task result.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootCorrelationTaskInfo

Represents a correlation analysis task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of CorrelationResultInfo records.
A measure of the correlation between each pair of numeric variable is calculated.
Since correlation is valid only for numeric values, non-numeric fields are ignored.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootOutlierDetectionTaskInfo

Represents an outlier detection analysis task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

OutlierCount (Integer ):
Number of top outliers to find (keep this value low for performance reasons)
OutlierNeighbors (Integer ):
Number of neighbors to consider to find outliers (keep this value low for performance reasons)
OutlierCandidateBatchSize (Integer ):
Number of data rows loaded together before being compared with other data rows
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of OutlierDetectionResultInfo records.
Data rows are loaded in batches, and compared to other data rows.
Data rows whose average distance to their closest N neighbors is the greatest are considered outliers.
Callers must specify the batch size, how many outliers to find, and how many neighbors to consider.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootAssociationTaskInfo

Represents an association rule analysis task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

MaxNumericBuckets (Integer ):
Number of buckets used to discretize numeric values
MaxDiscreteBuckets (Integer ):
Number of buckets used to process discrete values
TargetDimension (Integer ):
Size of association rules to find (typical values range from 2 to 4)
MinDensityThreshold (Double ):
Minimum density threshold required to keep a discovered association between fields
MaxDensityHypercubes (Integer ):
Maximum number of discovered associations to keep during each pass
ShrinkNumericDensityIntervals (Boolean ):
Whether the description of association rules should be modified to fit processed data
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of AssociationResultInfo records.
Numeric variables are discretized by taken into consideration N equal-sized numeric buckets (ex: age field: 0 to 20, 20 to 40, etc.).
Discrete variables are constrained by taken into consideration only the most frequent N discrete values.
Then, combinations of such variables (called hypercubes) are generated, and occurences of each combination counted.
Hypercubes are combined with other hypercubes, generating larger combinations of variables.
Callers can specify the maximum number of hypercubes so as to prevent excessive memory usage.
Callers can specify the minimum number of instances (called density) required to keep a hypercube.
The density is simply the percentage of data rows matching the hypercube (ex: 0.01 = 1% of data rows analyzed).
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootNumericDecisionTreeTaskInfo

Represents a numeric decision tree task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

MaxEquiDistributionProbability (Double ):
Required min probability of having different child distributions as a result of a split
TargetFieldInfoId (Guid ):
ID of the data field containing numeric values and for which to build a decision tree
MaxDepth (Integer ):
Maximum depth allowed for the decision tree
MaxSplit (Integer ):
Maximum number of child branches allowed when splitting on a discrete value
MinDensityThreshold (Double ):
Minimum density threshold required to split further
CurrentDepth (Integer ):
Depth at which the task is currently processing data
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of DecisionTreeResultInfo records.
This task can be used to build decision trees for a numeric target field.
At each level, a split using different fields and values is considered, and the target field's distribution is observed.
The algorithm selects the split having the most impact on the target field's distribution.
Statistical tests are used to determine how different distributions would be in each child branch, if a split was performed.
If distributions appear quite similar between child branches, then no split is performed.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootDiscreteDecisionTreeTaskInfo

Represents a discrete decision tree task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

MinGainRatioImprovement (Double ):
Min gain ratio improvement required to create a split
MinEntropy (Guid ):
Min entropy required to split further
TargetFieldInfoId (Guid ):
ID of the data field containing numeric values and for which to build a decision tree
MaxDepth (Integer ):
Maximum depth allowed for the decision tree
MaxSplit (Integer ):
Maximum number of child branches when splitting on a discrete value
MinDensityThreshold (Double ):
Minimum density threshold required to split further
CurrentDepth (Integer ):
Depth at which the task is currently processing data
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of DecisionTreeResultInfo records.
This task can be used to build decision trees for a discrete target field.
At each level, a split using different fields and values is considered, and the target field's distribution is observed.
The algorithm selects the split having the most impact on the target field's distribution.
Statistical tests are used to determine how different distributions would be in each child branch, if a split was performed.
If distributions appear quite similar between child branches, then no split is performed.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootClusteringTaskInfo

Represents a cluster identification analysis task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

AutoCluster (Enum ):
Auto-cluster mode to use
ClusterCount (Integer ):
Specific number of clusters to identify (used only when manual mode is selected)
Outlier ratio (Double ):
Value from 0 to 1 indicating by how much cluster models should be simplified so as to filter out noise & outliers
MaxClusterCount (Integer ):
Maximum number of clusters to identify
ClustersFound (Integer ):
Number of clusters identified
PointsClustered (Integer ):
Number of data rows found to belong to one of the identified clusters
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of ClusteringResultInfo and ClusteringSummaryResultInfo records.
In manual mode, an exact number of clusters can be specified, for example 3 clusters to divide data rows into 3 groups.
In automatic mode, several clustering models are generated, and a best fit is selected.
To prevent automatic mode from generating models with an excessive number of clusters, a maximum cluster count can be specified.
To prevent noise or outliers from affecting clustering quality, an outlier ratio can also be specified.
For example, a 0.25 value means that cluster models will be simplified by 25% before data rows are assigned to each cluster.
Points that do not fit one of the simplified clusters will be reported as outliers.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

RootSomMapTaskInfo

Represents a similarity map task.
Actions: Retrieve, Create, Update, Delete, Start.
Click here to view properties.

Width (Integer ):
Width of the map (in number of cells)
Height (Integer ):
Height of the map (in number of cells)
Iterations (Integer ):
Number of training iterations to perform
MaxDiscreteValueInit (Integer ):
Maximum number of discrete elements to consider when initializing the map
ReinforcementCutoff (Double ):
Reinforcement cutoff for propagating to other cells
WorkspaceInfoId (Guid ):
ID of the workspace under which the task lives and containing data to process
TargetTableInfoId (Guid ):
ID of the data table containing data to process
OwningUserInfoId (Guid ):
ID of the user owning the task
Description (String):
Description of the task
CreatedBy (String ):
Name of the user who created the task
SampleSize (Integer ):
Number of random samples to consider
FieldInfoFilterXml (String ):
XML specfifying which fields to consider when processing data
SendNotification (Boolean):
Whether an e-mail should be sent upon task completion or failure
RunState (Enum ):
Current task execution state
RunStatus (String ):
Additional information about the task execution state (ex: progress, error, etc.)
ErrorCode (Enum ):
Current task execution error code
Generation (Integer ):
Generation of the task (normally 0, but 1 or higher for failed & restarted tasks)
Id (Guid ):
ID of the task
DateCreated (Date ):
Date the task was created

Click here to view usage notes.

This task generates task results in the form of SomMapResultInfo and SomMapDistanceResultInfo records.
Data rows are projected to a 2D map made of cells, using a topology preserving algorithm.
This allows similar data rows to be mapped to identical or neighboring cells.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

TimeSeriesResultInfo

Represents a time series forecasting task result.
Actions: Retrieve.
Click here to view properties.

Date (Date ):
Date of the forecast
Value (Double ):
Value of the forecast
Min100 (Double ):
Min value when taking into consideration 100% of monte-carlo deviations
Max100 (Double ):
Max value when taking into consideration 100% of monte-carlo deviations
Min95 (Double ):
Min value when taking into consideration the most central 95% monte-carlo deviations
Max95 (Double ):
Max value when taking into consideration the most central 95% monte-carlo deviations
Min85 (Double ):
Min value when taking into consideration the most central 85% monte-carlo deviations
Max85 (Double ):
Max value when taking into consideration the most central 85% monte-carlo deviations
Min75 (Double ):
Min value when taking into consideration the most central 75% monte-carlo deviations
Max75 (Double ):
Max value when taking into consideration the most central 75% monte-carlo deviations
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootTimeSeriesTaskInfo tasks.
Each result represents a single forecast, and includes an estimate of possible variations.
For more information about executing tasks, click here.

CorrelationResultInfo

Represents a correlation analysis task result.
Actions: Retrieve.
Click here to view properties.

XFieldId (Guid ):
First field correlation was calculated for
YFieldId (Double ):
Second field correlation was calculated for
Correlation (Double ):
Estimate of the correlation
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootCorrelationTaskInfo tasks.
Each result specifies the correlation between a pair of numeric fields.
For more information about executing tasks, click here.

OutlierDetectionResultInfo

Represents an outlier detection task result.
Actions: Retrieve.
Click here to view properties.

AverageDistance (Double ):
Average distance to neighbors of the outlier
Random (Integer ):
Random value designating a data row which is an outlier
NeighborsXml (String ):
XML specifying the random values of neighbors and the distance to these neighbors
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootOutlierDetectionTaskInfo tasks.
Each result corresponds to a single outlier, and specifies neighbors and distance information.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

AssociationResultInfo

Represents an association rule task result.
Actions: Retrieve.
Click here to view properties.

Expected (Integer ):
Count of data rows expected to satisfy the association's preconditions assuming independence between variables
Actual (Integer ):
Count of data rows found to satisfy the association's preconditions
Strength (Double ):
Value representing the strength of the association
RuleXml (String ):
XML specifying association preconditions (priors)
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootAssociationTaskInfo tasks.
Each result corresponds to a single association, and specifies preconditions for the association.
For more information about executing tasks, click here.

DecisionTreeResultInfo

Represents a decision tree task result (i.e. a split).
Actions: Retrieve.
Click here to view properties.

ParentDecisionTreeResultInfoId (Guid ):
ID of the parent decision tree task result (empty GUID if root split)
SplitFieldInfoId (Guid ):
ID of the field which was used for the current split
SplitFieldRestrictionXml (String ):
XML specifying the split (ex: "greater than X")
SplitFieldValue (String ):
String representing the split value (ex: if split on "greater than X" -> X)
SplitFieldCondition (Condition ):
Condition representing the split operator (ex: "greater than X" -> greater)
DistributionStatXml (String ):
XML specifying the target field's distribution before splitting
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootNumericDecisionTreeTaskInfo & RootDiscreteDecisionTreeTaskInfo tasks.
Each result corresponds to a single split, and specifies how the split was effected, as well as information about the target field's distribution.
For more information about executing tasks, click here.

ClusteringResultInfo

Represents a cluster detection task result used to report cluster memberships.
Actions: Retrieve.
Click here to view properties.

Cluster (Integer ):
Integer value representing a cluster
Random (Guid ):
Random value designating a data row which is a member of the cluster
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootClusteringTaskInfo tasks.
Each result specifies that a single data row is a member of a cluster.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

ClusteringSummaryResultInfo

Represents a cluster detection task result used to report cluster profiles.
Actions: Retrieve.
Click here to view properties.

Cluster (Integer ):
Integer value representing a cluster
Count (Integer ):
Number of data rows found to belong to the cluster
Outliers (Integer ):
Whether the cluster represents outliers or noise records
MultiDistributionStatXml (String ):
XML specifying the distribution taken by all data fields for all members of the cluster
ComplementMultiDistributionStatXml (String ):
XML specifying the distribution taken by all data fields for all non-members of the cluster
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootClusteringTaskInfo tasks.
Each result specifies profile information for a single cluster.
For more information about executing tasks, click here.

SomMapResultInfo

Represents a similarity map task result used to report cell memberships.
Actions: Retrieve.
Click here to view properties.

Random (Integer ):
Random value designating a data row which was mapped to the cell
X (Integer ):
X-coordinate of a cell on the similarity map
Y (String ):
Y-coordinate of a cell on the similarity map
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootSomMapTaskInfo tasks.
Each result specifies that a single data row was mapped to a cell.
For more information about executing tasks, click here.
For more information about sampling & identification, click here.

SomMapDistanceResultInfo

Represents a similarity map task result used to report cell profiles.
Actions: Retrieve.
Click here to view properties.

X (Integer ):
X-coordinate of a cell on the similarity map
Y (String ):
Y-coordinate of a cell on the similarity map
DistanceRight (Double ):
Distance to the cell located immediately to the right of the current cell
DistanceBelow (Double ):
Distance to the cell located immediately below the current cell
Count (Integer ):
Number of data rows found to be mapped to the cell
MultiDistributionStatXml (String ):
XML specifying the distribution taken by all data fields for all data rows mapped to the cell
Id (Guid ):
ID of the task result
OwnerId (Guid ):
ID of the task owning the task result
Generation (Integer ):
Generation of the task owning the task result (normally 0, but 1 or higher for failed & restarted tasks)

Click here to view usage notes.

This type of task result is generated by RootSomMapTaskInfo tasks.
Each result specifies profile information for a single cell.
For more information about executing tasks, click here.

The following objects and enums are used to support entities:

RunState

Enum specifying the state a task is in.
Click here to view properties.

None = 0: the task has not been started
Scheduled = 1: the task has been started, but execution has not begun
Started = 2: the task has been started, and is being processed
Completed = 3: the task completed successfully
Failed = 4: the task failed during execution

Click here to view usage notes.

Tasks which have been created but not yet started have a RunState of None.
Tasks which have been started but for which execution has not begun have a RunState of Scheduled.
Tasks which have been started and are being processed have a RunState of Started (check the RunStatus property for progress).
Tasks which completed successfully have a RunState of Completed.
Tasks which failed during execution have a RunState of Failed (check the RunStatus and ErrorCode properties for details).
For more information about executing tasks, click here.

RightLevel

Enum specifying the right level granted to a user on a workspace.
Click here to view properties.

Read = 0: the right confers read access to a workspace
Write = 1: the right confers write access to a workspace
Manage = 2: the right confers manage access to a workspace

Click here to view usage notes.

For more information about managing rights, click here.

ApprovalLevel

Enum specifying the approval level for a given right.
Click here to view properties.

PendingApproval = 0: the right has been granted, but has not been approved by the recipient
Approved = 1: the right has been granted, and has been approved by the recipient

Click here to view usage notes.

For more information about managing rights, click here.

TableType

Enum specifying the type of data stored by a table.
Click here to view properties.

Data = 0: the table stores uploaded data
RootAlgorithm = 1: the table stores a root task
ChildAlgorithm = 2: the table stores a child task spawned by a root task
AlgorithmResult = 3: the table stores task results

Click here to view usage notes.

For more information about uploading data, click here.
For more information about executing tasks, click here.

FieldType

Enum specifying the type of data stored by a data field.
Click here to view properties.

UniqueIdentifier = 0: the field stores GUIDs
Text = 1: the field stores text
Bit = 2: the field stores booleans
Int = 3: the field stores integers
BigInt = 4: the field stores long integers
Double = 5: the field stores double-precision numeric values
Date = 6: the field stores dates

Click here to view usage notes.

For more information about uploading data, click here.
For more information about sampling & identification, click here.

FieldPurpose

Enum specifying the type of data stored by a data field.
Click here to view properties.

Unknown = 0: the field stores unknown data
Date = 1: the field stores temporal data
Rating = 2: the field stores rating data
Money = 3: the field stores monetary data
ScientificMeasure = 4: the field stores scientific measurement data
Location = 5: the field stores geographic data
Count = 6: the field stores count data
Classification = 7: the field stores classification data
Description = 8: the field stores description data
Naming = 9: the field stores naming data
Duration = 10: the field stores duration data
Proportion = 11: the field stores proportion data
RandomIdentity = 12: the field stores an identity used for random selection
HashSelection = 13: the field stores a hash value used for record indexing or selection

Click here to view usage notes.

For more information about uploading data, click here.
For more information about sampling & identification, click here.

AutoCluster

Enum specifying a clustering mode.
Click here to view properties.

Manual = 0: identify an exact number of clusters.
Best = 1: automatically identify the best number of clusters.
Low = 2: automatically identify the best number of clusters, but favor models with a lower number of clusters.
High = 3: automatically identify the best number of clusters, but favor models with a higher number of clusters.

Click here to view usage notes.

For more information about executing tasks, click here.

The following objects are used to support data transformation tasks:

TransformSequence

Represents a sequence of transformation steps to execute.
Click here to view properties.

Transforms (Transform[] ):
Sequence of transformation steps to execute

Click here to view usage notes.

For more information about transforming data, click here.

CreateTransform

Represents a transformation step which creates a field.
Click here to view properties.

FieldInfoId (Guid):
ID to assign to the field to create
FieldDescription (String):
Description of the field to create
FieldType (Enum):
Type of field to create (Enum)
Description (String):
Optional description for the transformation step

Click here to view usage notes.

For more information about transforming data, click here.

RenameTransform

Represents a transformation step which renames a field.
Click here to view properties.

FieldInfoId (Guid):
ID of the field to rename
FieldDescription (String):
New description of the field to rename
Description (String):
Optional description for the transformation step

Click here to view usage notes.

For more information about transforming data, click here.

ConvertTransform

Represents a transformation step which converts a field to a new type.
Click here to view properties.

FieldInfoId (Guid):
ID of the field to convert
FieldType (Enum):
Field type to convert to
FieldDefaultValue (Value ):
Field default value if conversion fails
Description (String):
Optional description for the transformation step

Click here to view usage notes.

Set the default value based on the new field type.
For example, for a date field, specify a date value, or null (for missing).
For more information about transforming data, click here.

DeleteTransform

Represents a transformation step which deletes a field.
Click here to view properties.

FieldInfoId (Guid):
ID of the field to delete
Description (String):
Optional description for the transformation step

Click here to view usage notes.

For more information about transforming data, click here.

SampleTransform

Represents a transformation step which randomly samples data.
Click here to view properties.

SampleMode (SampleMode ):
Description (String):
Optional description for the transformation step

Click here to view usage notes.

Set the sample mode to a CountSample or ProportionSample object.
For more information about transforming data, click here.

FilterTransform

Represents a transformation step which filters rows of data.
Click here to view properties.

DeleteRows (bool):
Whether rows matching the condition restriction should be kept or skipped
ConditionRestriction (SelectConditionRestriction ):
Filtering condition restriction specifying which rows to filter or skip
Description (String):
Optional description for the transformation step

Click here to view usage notes.

For more information about transforming data, click here.

RankTransform

Represents a transformation step which ranks rows and then sets a field to the rank.
Click here to view properties.

FieldInfoId (Guid):
ID of the field to receive the rank
WithTies (bool):
Whether ties are allowed when ranking rows
ConditionRestriction (SelectConditionRestriction ):
Filtering and ordering condition restriction specifying which rows to rank, and in which order to rank them
Description (String):
Optional description for the transformation step

Click here to view usage notes.

For more information about transforming data, click here.

ScrambleTransform

Represents a transformation step which replaces a field by a scrambled text equivalent.
Click here to view properties.

FieldInfoId (Guid):
ID of the text field to receive scrambled values
ScrambledFieldInfoId (Guid):
ID of the field to scramble
Prefix (Guid):
Optional prefix to use when scrambling data
ConditionRestriction (SelectConditionRestriction ):
Filtering condition restriction specifying which rows to apply scrambling to
Description (String):
Optional description for the transformation step

Click here to view usage notes.

If two original values are identical, they scrambled equivalents will be the same as well.
This makes it possible to know that two values are identical, but without knowing their original value.
For more information about transforming data, click here.

SetTransform

Represents a transformation step which sets a field to a fixed or dynamic expression.
Click here to view properties.

FieldInfoId (Guid):
ID of the field to set
Expression (Text):
Fixed or dynamic expression
FieldDefaultValue (Value ):
Field default value if computing or setting the calculated value fails
ConditionRestriction (SelectConditionRestriction ):
Filtering condition restriction specifying which rows to set a field for
Description (String):
Optional description for the transformation step

Click here to view usage notes.

Set the default value based on the field type.
For example, for a date field, specify a date value, or null (for missing).
Example fixed numeric expression: 0.13.
Example dynamic numeric expression: [field1_name] + log([field2_name] + 0.13).
Example fixed text expression: "X".
Example dynamic text expression: [field1_name] + sub([field2_name], 0, 2) + "X".
Example fixed boolean expression: false.
Example dynamic boolean expression: (10 < [field1_name]) || [field2_name].
Example fixed date expression: #12/31/2010#.
Example dynamic date expression: addday([field1_name], day([field1_name])).
Logical functions: (, ), <, <=, >, >=, =, ==, !=, <>, !, not, ||, or, &&, and
Text functions: +, len(x), sub(x,pos,len), repl(x,old,new), trim(x), lower(x), upper(x), indexof(x,v), startsw(x,v), endsw(x,v), contains(x,v)
Numeric functions: +, -, *, /, ^, %, min(x,y), max(x,y), abs(x), sign(x), floor(x), ceil(x), round(x,prec), exp(x), log(x), rand()
Date functions: msec(x), sec(x), day(x), mth(x), yr(x), addmsec(x,v), addsec(x,v), addmin(x,v), addday(x,v), addmth(x,v), addyr(x,v)
For more information about transforming data, click here.

CountSampleMode

Represents a sampling mode where a specified number of rows are sampled at random.
Click here to view properties.

Count (Integer):
Number of rows to select

Click here to view usage notes.

For more information about transforming data, click here.

ProportionSampleMode

Represents a sampling mode where a proportion of rows are sampled at random.
Click here to view properties.

Proportion (Double):
Proportion of rows to select (from 0 to 1)

Click here to view usage notes.

For more information about transforming data, click here.