Tables: price lists, catalogues and other data in rows
A table is for information that comes in rows and columns, such as a price list, a product catalogue, a list of branches with opening hours, or a customer or order list. Instead of reading a spreadsheet like a document, the assistant searches and filters the table when a question calls for it, and writes its answer from the exact rows it finds.
Use a table when the question is "what is the price of X". Use a document when the answer is a paragraph, such as a policy or a guide.
Prepare your file
- Save the spreadsheet as a CSV file. Excel, Google Sheets and most other tools can export one.
- Put the column names in the first row. Keep them short and clear, and make each one different.
- Keep each column to one kind of value, for example all prices or all dates written the same way.
- Remove empty columns and fill in as many cells as you can.
Import a table
- In the left rail, click My Assistants, open the assistant and click the Knowledge tab.
- Click Add knowledge, choose A table, and then click Tables in this workspace.
- The page is titled Tables. It lists the tables in your workspace with Name, AI Instructions, Rows and Updated. Click Import table data.
- In Import Table Data, click Click to choose a CSV file, or drag a file onto it. Only .csv files are accepted. Click Continue.
- Type a Table Name, for example prices, and click Continue. Use only letters, numbers and underscores, up to 13 characters. If the name does not fit, the screen says: Alphanumeric and underscore only, max 13 chars.
- The last step says Ready to import. This may take a moment. Click Start Import.
When it finishes you see a message such as "Imported 120 rows into prices", and the table opens.
Importing the same file twice makes two tables, so give each import its own name.
Let an assistant use the table
A table is stored in your workspace and read only by the assistants you add it to.
- Open the assistant, click the Knowledge tab and click Add knowledge.
- Under Already in this workspace, find the table and click the + beside it. If the list is long, use the link under it to see everything.
The table now shows in the assistant's list of what it reads, with a line such as "Table · 120 rows". Click it to open the table. To stop one assistant reading it, click Stop reading on its row. The table stays in the workspace and other assistants keep using it.
Tell the assistant what the table holds
Each table has AI Instructions. This is where you explain what the table contains and how to look things up. Good instructions are what make a table get used.
- On the Tables page, click + Add instructions on the table's row. Once it has instructions, the pencil button reads Edit instructions. These controls are available to workspace owners and admins.
- In AI Instructions, write what the table is, which column to search by, and anything about how to show values. The example on screen is: This table contains customer information. When looking up a customer, search by their email address or customer ID.
- Click Save.
How the assistant uses a table
- It can see which tables it has, look at their columns, search for text across all columns, and pick out rows that match a condition. It does this only when the question calls for it.
- It reads the table at the moment it answers, so a cell you edit is used in the next reply.
- It writes the answer in its own words, summarising the rows it found. If a value must appear exactly as it is in the cell, say so in the instructions, for example: Quote the price and SKU exactly as written in the table.
Look at or change a table
- On the Tables page, click the table's name.
- Click a row to see and edit its values, then click Save changes.
- Click Add Row to add one row, or Bulk Add to add several at once.
- Deleting a row asks you to confirm in Delete row?. Undo last action reverses the most recent change.
- Click Show system fields to see the columns Eloquens adds for its own use.
- Click Back to tables to return to the list.
To replace a whole table with fresh data, delete it and import the updated file, then add it to your assistants again.
Delete a table
- On the Tables page, click the bin icon on the table's row. It is shown to workspace owners and admins.
- Confirm in Delete table?.
The table is removed and every assistant that read it stops using it.
Tips
- Start with one or two tables that answer your most common questions, then send a test email to check the assistant finds the right rows.
- Use different tables for different kinds of data rather than one big table.
- Name tables for what they hold, such as prices or branches.
- Keep tables up to date. An old price list gives old answers.
- If the assistant ignores a table, check that it was added to that assistant, that the instructions name the column to search by, and that the question really is about what is in the rows.
Soma Konate
Comments