Next revision | Previous revisionNext revisionBoth sides next revision |
transformations:sandbox [2016/06/12 11:34] – created dmitry | transformations:sandbox [2021/03/28 15:43] – craigt |
---|
===== Sandbox ===== | {{ transformations:SandboxAction.png}} |
| ====== SANDBOX====== |
| Category: Create / Input\\ |
| |
Creates a temporary table which is typically used for one-time calculations. Sandboxes can be populated with result data of any transformation, or pasted from the clipboard. | \\ |
| =====Description===== |
| This action creates a temporary table that is typically used for one-time calculations. Sandboxes can be populated with result data of any action, or pasted from the clipboard. |
| |
Data in sandboxes survives reloads -- sandbox contents doesn't change on partial or full reloads. Although, it doesn't survive re-opening the project. When a project with a Sandbox transformation is opened all its sandboxes are empty. | Data in sandboxes survives reloads - contents don't change on partial or full reloads - although it doesn't survive re-opening the project. When a project is opened all of its sandboxes start empty.\\ |
| |
| \\ |
| =====Use cases===== |
Besides ad hoc calculations, sandboxes can be used in a few more cases: | Besides ad hoc calculations, sandboxes can be used in a few more cases: |
* Together with [[transformations:either|Either table]] transformation Sandbox can be used to safely insert an arbitrary dataset into any point of a transformation chain, which can be useful for debugging and development purposes. In this scenario insert [[transformations:either|Either table]] and point its second input to a table created using Sandbox transformation. | |
* Sandboxes can be used to create an empty table as a starting point for further transformations. Some transformations (e.g. [[transformations:runprogram|Run external program]] might not need an input dataset, but they don't create a table. In this case a generic empty table can be created using Sandbox, and then [[transformations:runprogram|Run external program]] can be inserted after it. | |
| |
Sandbox transformation has no parameters. | * Since Sandboxes survive reloads, you can compare a workflow result before and after changes. Send the result to a Sandbox, make changes in the workflows, then compare the new result with the old result in the Sandbox. |
| * Together with [[transformations:either|Either table]] transformation Sandbox can be used to safely insert an arbitrary dataset into any point of a transformation chain, which can be useful for debugging and development purposes. In this scenario insert [[transformations:either|Either table]] and point its second input to a table created using Sandbox transformation.\\ |
| |
**See also** | \\ |
| =====Populating a Sandbox with data===== |
| ^Option^Description^ |
| |Paste data|This option will paste data that has been copied to the clipboard. Options for //headers//, //delimiters//, and //decimal//\\ provide fine-tuning of the pasted data.| |
| |Import dataset|This option allows for browsing to and selecting an external dataset (.dset file) to populate the Sandbox with.| |
| |
| \\ |
| =====Creating and Populating a Sandbox from another action===== |
| By right-clicking an action that generates output data and selecting //Send to sandbox/module// > //New sandbox//, you create a new sandbox populated with the data from the source action. Selecting //New sandbox in new group// creates a new group and inserts a new sandbox action populated with the data from the source action. |
| |
| \\ |
| =====Shortcuts===== |
| Fast ways to create the action: |
| * Right-click an action and select "Send to sandbox/module", then "New sandbox" or "New sandbox in new group" (as described above). |
| * First copy data to the clipboard from an internal or external source, and: |
| * Press the "Add data" menu button. Pick "Paste from clipboard", or |
| * Right-click the application window and select "Paste data". |
| |
| |
| \\ |
| =====See also===== |
* [[http://http://easymorph.com/learn/data-analysis.html| Tutorial: Data analysis]] | * [[http://http://easymorph.com/learn/data-analysis.html| Tutorial: Data analysis]] |
* [[transformations:either|Either table]] | * [[transformations:either|Either table]] |