Explore from Existing Queries

Altering an existing Spreadic query is often faster than creating a new one from scratch. The Spreadic UI has a feature enabling you to explore from or make changes to a Spreadic query:

1. Click on the cell that contains the Spreadic function that you are interested in.

2. Select from the UI menu Load from Cell. You will then see all the selections needed to generate the query, allowing you to make changes to those selections. For example, you can add a filter to the query or pick a few more columns.

3. If you want to apply the changes to the same cell, simply hit FETCH DATA and the cell will refresh with the new selections applied. However, if you want to create a new query based on these new selections, you should pick another cell before hitting FETCH DATA.

Where on the sheet the data is going to appear depends entirely on which cell is being selected when you click on FETCH DATA. That makes it easy to duplicate a query or to create a new one by altering some of the parameters.