Skip to main content

The agent answers figures that aren't in the table

Symptom​

You ask for a value from a CSV or Excel you uploaded to Fuentes and the agent answers a figure that isn't in the table, citing the file and the column as if it had read it. In other attempts it concludes that data is missing when it does exist.

It happens with large tables; it was observed with one of 12,346 rows.

Cause​

The agent read only part of the table. With the Leer CSV y Excel (Read CSV and Excel) tool it listed the files, inspected the columns and read one page of rows, without using the analysis operation with filters. With the little it saw, it completed the answer.

With the Herramientas (Tools) preset at Normal, the agent uses up its calls paging through rows and concludes that the value doesn't exist.

How to confirm it​

  1. Below the response, expand N herramientas usadas (N tools used).
  2. Check the operations: if it only listed files, inspected the schema and read one page of rows, it didn't analyze the whole table.
  3. Open the file and check the figure. If it doesn't appear in the cited column, this is the case.

Solution​

  1. Ask the agent to show the operation it ran on the table.
  2. In Instrucciones > Ajustes avanzados (Instructions > Advanced settings), raise the Herramientas preset to Intensivo.
  3. If the table has thousands of rows, filter the file beforehand to what the question needs (for example, one year or one region) and upload that version to Fuentes. This is what helps most: asking in the instructions to filter is not enough.
  4. Always check the figure against the table before using it.

Next step​