Append

This activity allows the user to append the input datatable to the specified CSV file. It allows you to write the input data after the last line of the current data in the file.

Properties

INPUT

AppendData:* This parameter indicates you to specify the input datatable that is required to append in the existing specified CSV file.
It accepts input in “Datatable” datatype. 

You can either hardcode the values in “Datatable” format or provide the values in “Datatable” format variable.  

Delimiter: This parameter refers to a character used to separate values in a CSV file. Select the delimiter from the drop-down menu:

Comma (,): Use this when the data in the input sheet is separated by commas.
Tab: Use this when the data in the input sheet is separated by tabs.
Semicolon (;): Use this when the data in the input sheet is separated by semicolons.
Pipe (|): Use this when the data in the input sheet is separated by pipes.
Caret (^): Use this when the data in the input sheet is separated by carets.

Filepath:* This parameter requires you to provide the path of the CSV file to execute the activities.

Datatype: This parameter accepts input values in the “String” datatype.
Browse Option: You can browse and select the file using the “Browse” option in the activity.
Manual Entry: Alternatively, you can either hardcode the input value in “String” format or manually provide the values in “String” datatype.

Hasheader: If this option is enabled, the first row in the specified CSV file will be treated as the header. If it is not enabled, the first row will not be considered a header.

Ignorequotes: If this option is enabled, the quotes in the data will be ignored during the reading process.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

AppendStatus: It helps the user to view the status of the data appended in the provided CSV file. It returns values in “Boolean”.

True: Indicates that the data has been appended successfully without any errors.
False: Indicates that the data has not been appended successfully due to an unexpected error being thrown.

Result: It provides the ability to view the execution status of the activity. It returns values in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

*Represents mandatory fields to execute the workflow.