Manual Input
Type a table into a grid of column names and rows. Use it for examples, tests, lookup values or other small datasets; blank cells become NULL.
Create a small table
Manual Input holds three delivery options. Edit the Data grid and watch the output preview change.
Manual Input interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| code | label | amount |
|---|---|---|
| 001 | Standard | 12.5 |
| 002 | Express | 20 |
| 003 | Collection |
- Change
StandardtoEconomyin thelabelcolumn and look for the updated value in the output. - Enter
0in the emptyamountcell for Collection. Compare that value with the missing value shown before the edit. - Right-click a cell and choose Add row below, then fill in the new row. You can also hover near a row edge and select the + control to add a row.
- Right-click a cell and choose Add column right, then give the new column a name. You can also hover near a column edge and select the + control.
When to use
Use Manual Input for small tables you can type: lookup lists, test data or a few values to try a flow with. For anything larger, or data that changes elsewhere, load it with Input.
Read the output
Manual Input creates one output table from the Data grid. Column headings become the output column names, and each grid row becomes a row in the table. In this example, code, label and amount each contain three values.
Manual Input infers column types automatically, using the same detection as Auto Field. The code 001 keeps its leading zeros, and the amount 12.50 becomes a number you can sum. Typing a formula doesn't calculate anything.
Read blank cells correctly
The Collection row ends with a blank amount cell. Its output is NULL, meaning no value is present. That is different from 0, which is an entered value. A completely blank row still gives a row of NULL values. It isn't removed automatically.
Shape the grid
Edit column headings to name your data. Right-click a cell to insert or delete rows and columns. To add one directly from the grid, hover near a row or column edge and select the + control that appears. At least one column must remain. Removing all rows leaves an empty table that keeps its column headings.
The grid's contents are saved with the block configuration.
For data from a file or an external service, use Input.
Inputs and outputs
Inputs
0 portsNo input ports
This block has no incoming connection.
Outputs
1 port- Out
The table entered in Data, with its column names and rows. Column types are inferred as in Auto Field; blank cells become NULL.
Configure the block
- Clean whitespace
Trim leading and trailing whitespace before type inference. When off, text retains whitespace, including whitespace-only cells. Empty strings always become NULL.
Default:
true- Data
Manually entered table. Blank cells become NULL.
Default grid · 2 columns, 2 rows Column1 Column2 Blank Blank Blank Blank
Manual Input FAQs
- Does Manual Input need an input connection?
- No. Manual Input is a source block. It creates a table from the Data grid without an incoming connection.
- Does Manual Input convert numbers and dates automatically?
- Yes. Manual Input uses the same type inference as Auto Field. Columns whose non-NULL values all match a supported type are converted automatically. Integer-like codes with leading zeros stay as text.
- What happens to blank cells?
- Empty cells become NULL, a missing value. Typing 0 gives the number 0, which isn't the same as leaving the cell empty.
- How do I add or remove rows and columns?
- Right-click a cell to add a row above or below, add a column to the left or right or delete its row or column. You can also hover near row or column edges and select the + control to insert one. At least one column must remain. Edit a column heading to rename it.
- Where is manually entered data saved?
- The Data grid is stored in the block configuration as part of the project. It doesn't require a separate file or connector. Changes you make in this example stay in the example.
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.