The Update CSV Column
block allows users to efficiently modify an existing CSV file by either updating a designated column with new data or adding a new column altogether.
I/O | Feature | Type | Simple Explanation |
---|---|---|---|
input | csv_file_name | file | The target CSV file that needs modification, which must be in .csv format. |
input | column_index | number | Identifies the position of the column to update (0 for the first column). |
input | has_headers | boolean | Indicates whether the first row contains headers, helping determine how to process incoming data. |
input | is_new_column | boolean | Specifies if the designated column for updating is newly created or has existed previously. |
input | column_contents | string[] | New values that will populate into the specified column; each entry aligns with a row in the original CSV. |
output | updated_csv_file_name | file | The resultant new CSV file name generated after incorporating updates or new columns. |
Here’s how this block can streamline various tasks:
In essence, any scenario requiring updates or enhancements within a CSV can be efficiently handled using the Update CSV Column
block!