Send to Table copies rows from one table into another. Lookup in Table does the reverse: it pulls a value from another table into this one. Both are labelled Free.
Send rows to another table
Click Add column, then Add enrichment.
Open the Export tab and click Send to Table.
Under Destination, pick the table the rows go to. Pick a table that already has the columns you want to fill.
Choose a Method. Send row sends one destination row per row in this table. Send row for each item in a list is the other option.
In Column Mapping, untick any column you don't want to send. The count updates, for example "All columns (2 of 3)". The text field next to each column holds the destination column name. When it matched an existing column, the values landed there.
Click the arrow next to the button and choose Add column without running.
Click the column's play button and choose Run all 5 empty rows. The dialog says "Spends nothing from your wallet".
Each row then says 1 record sent.
Avoid sending duplicates
In Advanced Settings, Update existing rows on re-run and Skip duplicates are both off by default. With both off, re-running the column sends every row again, so the destination gets duplicates.
To avoid that, switch on Skip duplicates. A Unique Key Column field appears. Pick the destination column to match on, such as a domain column. Always pick one: without a key, every row failed with "Unique key column is required when updating rows or skipping duplicates." Re-run cells then say Skipped duplicate.
Look up a value from another table
Click Add column, then Add enrichment, and search for
Lookup.Pick Lookup in Table. It says "Pull a value from another table".
Set Table to Search, the table to look in.
Set Target Column, the column there to match against.
Set Filter Operator to Equals or Contains.
Set Return Type to First match, Up to 100 matches or Match count.
For Value to look up, click the field, press
/, and pick the column in this table to search for.Choose Add column without running, then run it from the column's play button.
Cells say Record Found or No Record Found.
Add a looked-up field as its own column
Select a Record Found cell and press
Enterto see its fields.Hover a field and click Add to column.
Good to know
If the destination table was already open when you sent rows, reload the page to see the new rows and columns.
When you press
/, pick a column from the list. If you close the list without picking, a/stays in the field.Columns you add to this table later show up ticked in the Send to Table mapping. Check the count before you re-run.