Undo and Redo
1. Overview
1.1. Function Description
"Undo and Redo" provide more flexible operation and error correction capabilities during ETL editing. With these two buttons, users can easily revert to previous states, correct misoperations, or try different editing schemes again. The undo function makes error correction simple, while the redo function allows users to reapply previous operations, ensuring editing continuity. This improves the fault tolerance of ETL developers when designing and optimizing data processing flows, reducing errors and repetitive work caused by misoperations.
1.2. Usage Restrictions
- Must be used while editing the current page; after refreshing or exiting the editing page, undo and redo operations cannot be used.
- Undo and redo operations only record the last 30 steps each.
2. Usage Instructions
Click Undo to return to the node state before the latest operation, shortcut key "command/ctrl"+"z";
Click Redo to return to the node state before the undo operation, shortcut key "command/ctrl"+"shift"+"z".

After an ETL change, the corresponding change operation will be cached. "Undo" and "Redo" support up to 30 steps each; each time you undo or redo, one operation is cached. The cache is cleared after refreshing the page or exiting the editing page.
Operation cache: The cache is cleared after refreshing the page or exiting the editing page.
Dimension | Operation Object | Caching Timing |
Canvas Level | Node/Connection/Annotation | Node copy, delete, name modification |
Connection, auto layout, node movement | ||
Annotation add, edit, delete | ||
Node Level | Input Dataset | Entire node level, dataset selection confirmation does not need caching, dataset replacement |
Output Dataset | Dataset name edit, save directory modification, acceleration field setting, annotation edit | |
Add Calculated Column | Calculated field add/edit/delete | |
Merge Columns | New column name edit, merge column add/delete, delete original column selection, separator setting | |
Group Aggregation | Calculated field add/edit/delete, dimension and value modification/alias/aggregation method | |
Select Columns | Column select/deselect, rename, order adjustment | |
Row to Column | Operation column selection, fill column selection, aggregation type selection, primary key column selection, new column add/delete, new column name same as original row value check | |
Column to Row | Label column name edit, value column name edit, new column add/delete, new row name same as original column value check | |
Filter Data Rows | Filter rule add/delete/copy/edit, trigger condition setting | |
Remove Duplicates | Deduplication column add/delete | |
Replace Values | Replace column selection, replacement result write method modification, value not meeting replacement rule setting, replacement rule edit/delete | |
Replace Null Values | Replacement rule add, replacement value modification, replacement rule delete | |
Row Concatenation | Row concatenation rule selection | |
Data Join | Join column add/delete, pre/post join field selection, join type setting | |
SQL Input | Existing dataset order adjustment, each query SQL edit | |
Other Nodes | Cached at node level, internal |