Transformations
Learn about Nexadata's transformations.
22 articles
- Supported Data Transformations in Nexadata PipelinesNexadata Pipelines provide transformations to copy, filter, join, merge, and format data, ensuring efficient data preparation and analysis.
- 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 columnUse the Insert Column transformation in Nexadata Pipelines to add new columns with formulas or default values.
- 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: Parse DateConvert date values from any format into a standardized datetime format, including Unix epoch timestamps in seconds or milliseconds.
- 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: Stack RowsUse Stack Rows to combine datasets with matching schemas by vertically appending their rows into a single dataset.
- Transformation: UppercaseUse the Uppercase transformation in Nexadata Pipelines to standardize text by converting selected columns to uppercase.
- Transformation: Generate Unique IDAdd a globally unique identifier to each record in your dataset using the Generate Unique ID transformation