|
|
Dataset - Insert row |
Declaration
<AMDATASET ACTIVITY="insert_row" DATASET="text" ROWLOCATION="text (options)" INDEX="number"><COLUMNSETTER COLUMNNAME="text" VALUE="text" /></AMDATASET>
Description
Inserts a row anywhere in a dataset.
Practical Usage
Used to insert a row anywhere in a dataset.
Parameters
General
| Property | Type | Required | Default | Markup | Description |
|---|---|---|---|---|---|
| Dataset name | Text | Yes | (Empty) | DATASET="Customers" | Specifies the dataset to insert the row into. |
| Insert at | Text (options) | Yes | End |
|
Specifies where to insert the row at. The options are:
|
| Row index | Number | Yes, if Insert at is set to Row index | (Empty) | INDEX="5" | The row index number to insert the row at. This parameter is required if Insert at is set to Row index. NOTE: The row index number entered must be greater than 0. |
| Insert data | -- | -- | -- | -- | To include values in the row for one or more columns, enter the desired column names from the selected dataset, or click Load columns to automatically display all available columns after the dataset has been run at least once in the Task Builder. Then, enter the desired values. |
| Column name | Text | No | (Empty) | COLUMNNAME="Status"
|
The column name to insert the value under in the row. |
| Value | Text | No | (Empty) | VALUE="New" | The value to insert into the row. |
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 Dataset activities to create a dataset with three columns, and then appends a blank row at the end of it.
Copy
<AMDATASET RESULTDATASET="myDataset" COLUMNS="heading1;heading2;heading3" DELIMITER="semi_colon" DESCRIPTION="This is user input description showing in the variables panel of Task Builder" />
<AMDATASET ACTIVITY="insert_row" DATASET="myDataset" />