What Rote does.
Four jobs, all of them working in the current build. Anything not on these pages is either not built yet or not planned — and the planned list is at the bottom of this page.
The four jobs
Reusable jobsSave the steps you took and run them on next month's file. Rote checks the columns still match before it does anything, and stops rather than guessing if they do not.Clean tabular dataClean CSV files: trim stray spaces, remove blank rows and duplicates, rename and reorder columns, sort on several fields — and see every change before anything is written.Merge datasetsCombine two to four CSV files into one. Map columns that are named differently in each file, and decide what happens to the columns only some files have.Compare datasetsCompare two to four CSV files on the columns that identify a record, and get four groups: identical, different, only in the first file, only in the second.
Planned — not built yet
- Folder triggers
- Scheduling
- Batch processing
- Run history
- Failure notifications
- Schema and change detection
- Excel files (XLSX)
- Command line
- Email, Slack, Teams and webhooks
Be first to use Rote.
Rote is in development. Join the wishlist and we'll let you know when the beta is ready. If there is something you need it to do, ask.