Hi everybody,
An ongoing discussion on the forum is how many rows can Coda handle. In this video I give a short overview of a doc that I built that reconciles customer invoices in two different systems. The files are 28k and 34k rows respectively. An invoice number can have one or more lines, and the totals should be compared. One of the files is in Excel, the other is a fixed length text file. (With some inconsistencies… I could not get Excel to handle this at all, in Coda it was a breeze.)
Here is the video
If you would like to have access to the doc, please let me know. Since I only use numbers and not names, I can share.
Two takeaways - Coda can handle fairly large numbers of rows, but secondly, oftentimes there are ways to process large amounts of data without taking the brute force approach.
But it’s just a ramble
Rambling Pete