Dataset - Create

Declaration

<AMDATASET RESULTDATASET="text" COLUMNS="text" CUSTOMDELIMITER="text" DELIMITER="text (options)" DESCRIPTION="text" />

Related Topics   

Description

Creates an empty dataset.

Practical Usage

Used to create an empty dataset.

Parameters

General

Property Type Required Default Markup Description
Dataset name Text Yes (Empty) RESULTDATA="Customers" Specifies the dataset to create.
Initial column names as delimiter separated list (optional) Text No (Empty) COLUMNS="First name" The initial columns to insert into the empty dataset. To add columns, enter each column name, and then separate them using the desired Delimiter option below.
Delimiter Text (Options) Yes Comma
  • DELIMITER="comma"
  • DELIMITER="new_line"
  • DELIMITER="semi_colon"
  • DELIMITER="space"
  • DELIMITER="tabulation"
  • DELIMITER="custom"
 Specifies the delimiter to use to separate columns in this dataset. The options are:
  • Comma (default) - Separates each column using a comma.
  • New line - Separates each column on a new line.
  • Semicolon - Separates each column using a semicolon.
  • Space - Separates each column using a single space.
  • Tab - Separates each column using a tab character.
  • Custom - Separates each column using one or more characters of choice (for example, |).
Custom delimiter text Text No (Empty) CUSTOMDELIMITER="|" The custom characters to separate each column with. This parameter becomes active if Delimiter is set to Custom.
Description (optional) Text No (Empty) DESCRIPTION="Total customer base" The optional description of the dataset.

Description

Error Causes

On Error

Example

NOTE:
  • The sample AML code below can be copied and pasted directly into the Steps Panel of the Task Builder.
  • Parameters containing user credentials, files, file paths, and/or other information specific to the task must be customized before the sample code can run successfully.

Description

This task uses the Create and Insert Row activities to create a dataset with three columns, and then adds a row with values for those columns at the end of the dataset.

EXAMPLE:
<AMDATASET RESULTDATASET="myDataset" COLUMNS="heading1;heading2;heading3" DELIMITER="semi_colon" DESCRIPTION="This is user input description showing in variables panel of Task Builder" />
<AMDATASET ACTIVITY="insert_row" DATASET="myDataset"><COLUMNSETTER COLUMNNAME="heading1" VALUE="value1" /><COLUMNSETTER COLUMNNAME="heading2" VALUE="value2" /><COLUMNSETTER COLUMNNAME="heading3" VALUE="value3" /></AMDATASET>