Skip to main content
Sort data in a CSV
Wrk Product avatar
Written by Wrk Product
Updated over a week ago

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:

  • Unable to interact with the provided CSV

Requirements

  • N/A

Did this answer your question?