transformations:sandbox
This is an old revision of the document!
Sandbox
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.
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.
Besides ad hoc calculations, sandboxes can be used in a few more cases:
- Together with 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 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. 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 Run external program can be inserted after it.
Sandbox transformation has no parameters.
See also
transformations/sandbox.1465745689.txt.gz · Last modified: 2016/06/12 11:34 by dmitry