|
Dataset - Clone |
Declaration
<AMDATASET ACTIVITY="clone" RESULTDATASET="text" DATASET="text" DESCRIPTION="text" />
Description
Clones an existing dataset.
Practical Usage
Used to clone a dataset
Parameters
General
Property | Type | Required | Default | Markup | Description |
---|---|---|---|---|---|
Dataset name | Text | Yes | (Empty) | DATASET="Customers" | Specifies the dataset to clone. |
New dataset name | Text | Yes | (Empty) | RESULTDATASET="Customer base" | The name of the dataset clone. |
Description (optional) | Text | No | (Empty) | DESCRIPTION="Copy of Customers dataset." | The optional description of the dataset clone. |
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 three rows, and then clones the entire dataset as myNewDataset.
Copy
<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" ROWLOCATION="end"><COLUMNSETTER COLUMNNAME="heading1" VALUE="Row 1" /><COLUMNSETTER COLUMNNAME="heading2" VALUE="value2" /><COLUMNSETTER COLUMNNAME="heading3" VALUE="value3" /></AMDATASET>
<AMDATASET ACTIVITY="insert_row" DATASET="myDataset" ROWLOCATION="end"><COLUMNSETTER COLUMNNAME="heading1" VALUE="Row2" /><COLUMNSETTER COLUMNNAME="heading2" VALUE="value2" /><COLUMNSETTER COLUMNNAME="heading3" VALUE="value3" /></AMDATASET>
<AMDATASET ACTIVITY="insert_row" DATASET="myDataset" ROWLOCATION="end"><COLUMNSETTER COLUMNNAME="heading1" VALUE="Row3" /><COLUMNSETTER COLUMNNAME="heading2" VALUE="value2" /><COLUMNSETTER COLUMNNAME="heading3" VALUE="value3" /></AMDATASET>
<AMDATASET ACTIVITY="clone" RESULTDATASET="myNewDataset" DATASET="myDataset" DESCRIPTION="This is NEW user input description showing in variables panel of Task Builder" />