Answers to frequent questions about data transformation-from filtering and querying to templates, exports, and diagnostics.
Playground is a temporary workspace for exploring and transforming a file. Your progress there is autosaved as a draft, but nothing persists permanently until you click Save as Project or Save as Template.
No-your changes are autosaved as a draft while you work, shown by the Draft saved status in the toolbar. That said, a draft is a safety net, not a substitute for Save as Project if you want the work to show up in your permanent Projects list.
Save as Project if you want to keep this specific file's result and reopen it later. Save as Template if you plan to run the same transformation steps against other files in the future. You can do both for the same piece of work.
Open Filters in the toolbar, add a filter on the column you want to check, and choose the condition is empty to find missing values, or is not empty to exclude them.
Yes. Search, filters, sorting, and duplicate removal all apply together to the active table, and you can remove any one of them without resetting the others.
It only reads from the table you have open to generate a query-it never modifies or deletes data unless you explicitly build and run a separate write operation. Choose Create New to keep your original table untouched, or Modify Current to apply the result directly.
Try being more specific in your prompt-naming the exact column, value, or time range usually produces a more accurate query. You can also switch the model in the top-right of the panel, since different models can interpret the same request differently.
Running a template re-applies its saved queries and steps, usually against a newer version of the same file. The run count and last run date on that template update automatically once it completes.
No. Deleting a template only removes it from Template Manager-it doesn't affect any files or tables that were previously produced by running it.
Every file produced by a transformation, template run, or sync appears in Transformed Files, where you can preview, download, or export it further to Google Drive or FTP.
It reflects how clean and consistent your data is-lower scores usually point to missing values, mixed data types within a column, or duplicate rows. A score under 100% doesn't always mean something is wrong, since some source files naturally have gaps.
No-the Overview, Quality, and Columns tabs update automatically to reflect your current result, not just the original file, so you can check them again anytime without extra steps.
Can't find the answer you're looking for? Our support team is here to help with anything specific to your workspace.
Contact Support