Transformations
Learn about Nexadata's transformations.
Transformation: CopyUse the Copy transformation in Nexadata Pipelines to duplicate a column and specify its position in the dataset.
Transformation: FilterUse the Filter transformation in Nexadata Pipelines to include or exclude rows based on custom conditions.
Transformation: Flip signUse the Flip Sign transformation in Nexadata Pipelines to automatically adjust the sign of values based on custom conditions.
Transformation: Group byUse the Group By transformation in Nexadata Pipelines to group and summarize data with functions like sum, count, and average.
Transformation: Insert columnInsert Column in Nexadata Pipelines adds columns with default values. Calculations aren’t supported yet but are planned for future updates.
Transformation: Insert row numbersAdd sequential row numbers to your dataset using the Insert Row Numbers transformation.
Transformation: JoinCombine datasets in Nexadata with a common key, using graphical joins (inner, outer, left, right) for a custom, unified output dataset.
Transformation: KeepUse the Keep transformation to selectively retain essential columns while removing all others, streamlining your dataset.
Transformation: LowercaseUse the Lowercase transformation in Nexadata Pipelines to standardize text by converting selected columns to lowercase.
Transformation: MathUse the Math transformation to apply statistical operations across selected columns like sum, mean, median, and standard deviation.
Transformation: MergeUse the Merge transformation to combine selected columns into a single column with a custom delimiter, simplifying your dataset.
Transformation: RemoveUse the Remove transformation to delete unnecessary columns, streamlining your dataset for better focus and clarity.
Transformation: RenameUse the Rename transformation to update column names, enhancing clarity and consistency across your dataset.
Transformation: ReplaceUse the Replace transformation to find and replace values in a column, with options for exact matches or regex patterns.
Transformation: ShiftUse the Shift transformation in Nexadata Pipelines to reposition columns to the start, end, or relative to another column.
Transformation: SortUse the Sort transformation to arrange dataset columns in ascending or descending order, with options for empty value placement.
Transformation: SplitUse the Split transformation in Nexadata Pipelines to divide a column’s contents into multiple columns based on a specified delimiter.
Transformation: SumUse the Sum transformation in Nexadata Pipelines to compute and output a single-column sum for a selected numeric column.
Transformation: UppercaseUse the Uppercase transformation in Nexadata Pipelines to standardize text by converting selected columns to uppercase.
Supported Data Transformations in Nexadata PipelinesNexadata Pipelines provide transformations to copy, filter, join, merge, and format data, ensuring efficient data preparation and analysis.
Transformation: Stack Rows
Transformation: Insert column