Update Files
Infoveave Data Automation — File Reading
Add or correct exactly one row in a file — at the exact position you specify.
Many operational workflows need to write back to a structured file — appending a processed record to a master log, inserting a calculated result at a specific position in a report, or correcting a row that failed validation. Update Files handles this precisely: it adds a row at the index you specify, preserving the rest of the file intact. This eliminates the manual step of opening the file, finding the right row, and editing it before re-saving.
What Update Files does
Insert or update a specific row in an existing CSV or Excel file at a defined index position inside your Infoveave workflow. Automate log appending, row corrections, and data patching without opening files manually.
When to use Update Files
- You need to append a newly processed record to an existing master CSV or Excel file that accumulates results over time
- A workflow step produces a single-row result that must be inserted at a specific position in an existing structured file
- You are building an audit-log workflow where each workflow run appends one new entry to a running log file
- A row in an existing file needs to be corrected with updated values at a known index position
When to avoid it
- You need to write an entire new dataset to a file — use Write to File instead
- You need to update multiple rows at once — Update Files is designed for single-row insertions
- The output file does not yet exist — create it with Write to File first, then use Update Files for subsequent modifications
Where it fits in your Infoveave automation
Update Files is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Update Files
Real scenarios where this transformation saves hours of manual work.
Transaction Log Appending
After each automated payment processing run, Update Files appends the processed transaction summary to a master audit log CSV at the next available index. Finance teams always have a current, timestamped record of every automated payment cycle.
Patient Record Amendment
When a data quality validation step flags a correction, Update Files inserts the amended patient record at the correct row position in the daily discharge file before it is uploaded to the hospital management system.
Production Quality Log Updates
After each quality check automation run, the pass/fail result is appended to the running production quality log at the current shift's row index — creating an automatically maintained time-series audit trail.
See Update Files in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
2["104", "Diana", "Engineering", "88"]Input Data
| EmployeeID | Name | Department | Score |
|---|---|---|---|
| 104 | Diana | Engineering | 88 |
Output Data
| File | Size | Status |
|---|---|---|
| employees.csv | 3 KB | Updated (row inserted at index 2) |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Row Index Number
The position in the file where the new row will be inserted. Index 0 inserts before the first data row. The file structure after the insertion position is preserved.
Row Data
The data values for the row to insert, as an array matching the file's column structure. The number of values must match the file's column count and types to avoid structural errors.
Frequently asked questions
Everything you need to know about Update Files in Infoveave.
Also in File Reading — and what runs before & after
Transformations in the same family as Update Files, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Update Files is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
