Query a CSV using SQL

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	“
Output filename	Optional custom filename for the output CSV file	Text(Long)	No	sample.csv

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