Description
Appends a data table into the CSV.
Attributes
Input
DataTable - The data table to be appended to the selected CSV file.
Encoding - The type of encoding for the CSV.
Misc
DisplayName - Renames the activity.
Example
- Create a DataTable variable and name it dt.
- Add a Generate Data Table inside the initial Sequence.
- Select the Generate Data Table activity. In the DataTable field under Attributes, add the dt variable.
- Still under the Generate Data Table activity Attributes, write ";" in the ColumnSeparators field, and write "|" in the NewLineSeparator field.
- In the Generate Data Table Input field, type "1; Rhiza Recaido|2; Alysson Cepeda|3; Jheska Castillo".
This would be the sample values inside the data table. - Under the Generate Data Table, add a CSV Sequence.
- In the CSV Sequence File Path field, search and select the CSV document that you will use.
- In the CSV Sequence Delimiter field, write ','.
- Inside the CSV Sequence, add a CSV Append activity.
- In the CSV Sequence DataTable field, add the dt variable.
The use case should look as the following screenshot:
After the execution, the generated data table should be appended in the specified CSV document.