When configuring the RegEx tool to "replace," what does it append to the output data?

When using the RegEx tool in Alteryx set to "replace," it appends a column containing the replacement text to the output data. This functionality allows for the original data to remain intact while simultaneously adding a new column that reflects the transformed values based on the specified regular expression pattern and replacement text.

The intent of this output format is to enable users to maintain visibility of both the original and modified data within the data stream, facilitating better data analysis and validation processes. This is particularly useful when auditing changes made by regex operations or when incremental updates to datasets are needed without losing original context.

In contrast, the other options do not align with the behavior of the RegEx tool in "replace" mode. There is no mechanism within this configuration to generate a new row—any replacements occur within the context of existing rows. Similarly, a text file output is not generated directly by the RegEx tool unless further actions are taken, such as using an Output Data tool. Notifications about the operation's success are generally not part of the output data but may be indicated through the interface or logs.