Sort data in a CSV given specific sort criteria.
Application
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 | |
| Output filename | Optional custom filename for the sorted CSV file | Text(Long) | No | sample.csv |
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:Unable to interact with the provided CSV |
Requirements