Sort data in a CSV given specific sort criteria.
Application
CSV
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
CSV file | CSV file to sort | File | Yes | data.csv |
Sort criteria | Column name and sort order written as ColumnName SortOrder. SortOrder can be ASC or DESC. Note sort order favours special characters first then number then regular characters. Separate each column with a comma | Text(Long) | Yes | Name ASC |
Contains headers? | If the CSV contains headers that should be ignored in the sort | True/False | No |
|
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library section. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Sorted CSV file | Sorted CSV file | File | Yes | data.csv |
Outcomes
Name | Description |
Success | This status is selected if the CSV file was successfully sorted. |
Impossible to Complete | This status is selected in the event of the following scenarios:
|
Requirements
N/A