Input
Data Input
A small table you type or paste straight into the node — your own column names, types and rows — used as a data source like any file.
When to use it
Use it for lookup lists, test data, mapping tables or a handful of values that do not live anywhere else, without making a file first.
In a pipeline
Data InputJoin TablesExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Enter data as | select | — | table |
| Table | textarea | — | — |
| Delimited text | textarea | — | Name,City,Amount Ann,Paris,120 Bob,Oslo,85 |
| Delimiter | select | — | auto |
| Other delimiter | text | — | Any text, e.g. ~ or || |
| First row has column names | checkbox | — | true |
Example
A region mapping pasted from Excel
- Enter data as=Delimited text
- Delimited text=Code;Region;Target N;North;1200 S;South;950
- Delimiter=Semicolon ( ; )
| Code | Region | Target |
|---|---|---|
| N | North | 1200 |
| S | South | 950 |
Target is detected as a whole number, so it sorts and sums as one.
Worth knowing
- In table mode, paste cells copied from Excel, a CSV or a text file into any cell: the grid grows to fit and counts the rows. Paste into a column name to take the first line as names.
- Each column has a type (text, whole number, decimal, true / false, date …); a cell that does not fit is left blank and counted in the node's note.
- Delimited text splits on a comma, semicolon, colon, pipe or tab — or anything you type under Other, several characters included (||, ~|~).
- Detect automatically picks the delimiter that splits the lines most consistently, as CSV Smart Reader does.
- Keep it small: the data is saved inside the flow. For thousands of rows, use File Input.