Query Spreadsheet

warning

This component is being deprecated

It is recommended that if you need to query data from a spreadsheet, you perform this using the Database and Query Database. Create a new database by uploading your spreadsheet and then use the query database component to perform queries as required.

ComponentTypeDescription
imgQuery Spreadsheet๐Ÿ”€ actionUpload a spreadsheet and run dynamic data queries

The Query Spreadsheet component allows you to upload a spreadsheet and then construct queries that will be run when the workflow reaches the component.

Importing a spreadsheet#

Say for example that you have the following spreadsheet, which you want to extract data from during a workflow.

img

To import the spreadsheet, click the "Import Data" button.

img

A dialog will appear where you can drop in a spreadsheet file or click to select and upload. If the spreadsheet you are uploading has headers in the first row, select "First row contains headers". Click upload to import the data.

img

You can then see your spreadsheet loaded into the component.

img

Constructing a query#

To construct a query, click "Add Data Query". This will add a data query block.

img

Select a data query type you would like to perform. There are currently 3 options.

Select a column#

This simply outputs the selected column as a list. For example, extract all values in the "Order ID" column as a list every time the workflow is run. This can be used in combination with the โžก list transform to process and transform that list.

img

Select data is a condition is met#

This returns a list of values from one column where the corresponding values in another column are true. For example, you can have a query which returns a list of values in the "Order ID" column where the values in the "City" column is "Los Angeles".

For more details about the functions you can use in your statements, see โžก here

img

Return count if a conditional is met#

This returns a count of the number of times a statement is true in a column. For example, you can create a query to count the number of times "Los Angeles" is in the "City" column.

For more details about the functions you can use in your statements, see โžก here