MultiColumnEdit

This gem runs in .

Overview

The MultiColumnEdit gem primarily lets you cast or change the data type of multiple columns at once. It provides additional functionality, including:

The gem has a corresponding interactive gem example. See Interactive gem examples to learn how to run sample pipelines for this and other gems.

Parameter	Description	Required
Selected columns to edit	Choose which columns you want to transform.	Yes
Maintain the original columns and add prefix/suffix to the new column	If checked, the original columns will stay the same and new ones will be added with the prefix/suffix. Otherwise, the original column names change.	No
Prefix/Suffix dropdown	Lets you choose whether to add text at the beginning (prefix) or end (suffix) of the column names.	No
Build a single expression to apply to all selected columns	A SQL expression you apply to each selected column. If you don’t want to change the values, enter `column_value`.	Yes