Query a CSV using SQL. Wrk Action uses SQLite syntax.
SQLLite Documentation: https://www.sqlite.org/docs.html
Application
CSV
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
CSV file | CSV file you would like to query using SQL | File | Yes |
|
SQL query | A SQL query to perform on the provided CSV. Your primary table will always be referenced as CSV. Example: `Select * from CSV` | Text (Long) | Yes | Select * from CSV |
Columns do not have headers? | If selected, the headers will be referred to as Col1, Col2, etc | True/False | No |
|
Separator | The character used to separate columns in the CSV. Will default to , | Text (Short) | No | , |
Quote character | The characters used to indicate a string in the CSV. Will default to “ | Text (Short) | No | “ |
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Output CSV | Output CSV file | File | Yes |
|
Outcomes
Name | Description |
Success | This status is selected if the job has successfully completed. |
Examples:
Examples to come