Add Rows

Type a few records straight into your table. No spreadsheet round trip.

What it does

Add Rows puts new records at the bottom of your table. You type the values in a small form.

It is useful for the row that the export missed. A late expense claim, a walk-in sale, or a test record all fit.

The form shows one box per column. Each box is labelled with the column name and its type, such as amount (numeric).

Add a record

1. Type add rows in the Search transforms box, in the Pipeline panel.
2. Select Add Rows in the results. A card named Row 1 opens.
3. Fill in the boxes for Row 1. Leave a box empty for an empty cell.
4. Click Add another row for a second record.
5. Click the small cross on a card to remove that card.
6. Click Apply.

Your rows appear at the bottom of the grid. The step joins your pipeline, so you can edit it later.

What to type in each box

The grey hint inside each box tells you the format:

Each value converts to the column type when you apply.

A value that does not fit becomes an empty cell. The step never fails on one bad box.

So check a new row in the grid. An empty cell means the value did not convert.

Good to know

• An empty box makes an empty cell. Fill only the columns you know.
• A card with every box empty is skipped. Nothing is added for it.
• Do not type commas in numbers. Write 1250.50, not 1,250.50.
• Edit the step later to correct a typo. The Pipeline panel has an edit button on each step.
• New rows arrive last. Click a column header to sort the grid and find them in place.

Adding many rows?

This form suits a handful of records. Twenty rows of typing is slow work.

For bulk data, put the records in a second file. Then append that file with Union All.

For SQL users

One new row on a three-column table runs as:

SELECT "sku", "item", "qty" FROM "inventory"
UNION ALL
SELECT TRY_CAST('SKU-99' AS VARCHAR) AS "sku",
       TRY_CAST('Stapler' AS VARCHAR) AS "item",
       TRY_CAST('12' AS INTEGER) AS "qty"

Related Operations

• Join - Join with another file/table
• Unnest - Explode delimited column into rows
• Fill Missing - Fill null values