Transformations
Learn about Nexadata’s transformations.
Articles
Section titled “Articles”- Supported Data Transformations in Nexadata Pipelines — Nexadata Pipelines provide transformations to copy, filter, join, merge, and format data, ensuring efficient data preparation and analysis.
- Transformation: Copy — Use the Copy transformation in Nexadata Pipelines to duplicate a column and specify its position in the dataset.
- Transformation: Filter — Use the Filter transformation in Nexadata Pipelines to include or exclude rows based on custom conditions.
- Transformation: Flip sign — Use the Flip Sign transformation in Nexadata Pipelines to automatically adjust the sign of values based on custom conditions.
- Transformation: Generate Unique ID — Add a globally unique identifier to each record in your dataset using the Generate Unique ID transformation
- Transformation: Group by — Use the Group By transformation in Nexadata Pipelines to group and summarize data with functions like sum, count, and average.
- Transformation: Insert column — Use the Insert Column transformation in Nexadata Pipelines to add new columns with formulas or default values.
- Transformation: Insert row numbers — Add sequential row numbers to your dataset using the Insert Row Numbers transformation.
- Transformation: Join — Combine datasets in Nexadata with a common key, using graphical joins (inner, outer, left, right) for a custom, unified output dataset.
- Transformation: Keep — Use the Keep transformation to selectively retain essential columns while removing all others, streamlining your dataset.
- Transformation: Lowercase — Use the Lowercase transformation in Nexadata Pipelines to standardize text by converting selected columns to lowercase.
- Transformation: Math — Use the Math transformation to apply statistical operations across selected columns like sum, mean, median, and standard deviation.
- Transformation: Merge — Use the Merge transformation to combine selected columns into a single column with a custom delimiter, simplifying your dataset.
- Transformation: Parse Date — Convert date values from any format into a standardized datetime format, including Unix epoch timestamps in seconds or milliseconds.
- Transformation: Remove — Use the Remove transformation to delete unnecessary columns, streamlining your dataset for better focus and clarity.
- Transformation: Rename — Use the Rename transformation to update column names, enhancing clarity and consistency across your dataset.
- Transformation: Replace — Use the Replace transformation to find and replace values in a column, with options for exact matches or regex patterns.
- Transformation: Shift — Use the Shift transformation in Nexadata Pipelines to reposition columns to the start, end, or relative to another column.
- Transformation: Sort — Use the Sort transformation to arrange dataset columns in ascending or descending order, with options for empty value placement.
- Transformation: Split — Use the Split transformation in Nexadata Pipelines to divide a column’s contents into multiple columns based on a specified delimiter.
- Transformation: Stack Rows — Use Stack Rows to combine datasets with matching schemas by vertically appending their rows into a single dataset.
- Transformation: Uppercase — Use the Uppercase transformation in Nexadata Pipelines to standardize text by converting selected columns to uppercase.