Challenge consuming data from csv

HI – and apologies if this has been addressed elsewhere. I am trying to have Autopilot do some basic summarization of data in a .csv file (1 record per row), however it often only consumes a fraction of the rows of data (only talking about 50 rows, often it only has summarization for 15-20). Any tips on what I might be doing wrong, or how to refine the prompt (beyond asking it to consume all XX rows of data – which seems a bit much, and still doesn’t consistently get me an accurate result)

Thanks for any tips/pointers,
Chris

Hi @christopher.puglise

Pls check for more:

If you found helpful, Mark as a solution tick .
Happy Automation

“I’ve run into something similar before, Autopilot seems to sometimes cuts off when handling CSVs with multiple rows. What helped me was splitting the file into smaller chunks or guiding it with more structured prompts (like asking for summaries in batches of 10–15 rows). Might be worth testing if that gives more consistent results.”

Thanks for the suggestion, will give it a try! Up to this point, even for small files (50 rows) I don’t get 50, and rarely get the same answer twice. Will suggest it consumes the file 10 rows at a time.

@christopher.puglise

Welcome to the community

How are you passing it?

There is a input limit as well so that might be an issue

Cheers

Thanks for the response, I was simply attaching a .csv file. Is there another approach I should take, or a way to “chunk” the input so the tool grabs what it can consume, then moves to the next part?

@christopher.puglise

try to save the csv as text file with .txt and then try to feed it

cheers

Thanks, saving as a tab delimited text file seems to be helping. Still having issues with properly categorizing the entries (ticket severity) – but will keep playing with it.

I appreciate the suggestion!

1 Like