visual-data-transformation-builder
Construct data transformations through a visual, step-by-step interface without writing code. Users click through operations like filtering, sorting, and reshaping data, with each step automatically generating M language code in the background.
intelligent-column-type-inference
Automatically detect and assign appropriate data types (text, number, date, boolean) to columns based on content analysis. Reduces manual type-setting and catches data quality issues early.
data-append-and-union
Stack multiple datasets vertically to combine rows from different sources. Automatically aligns columns by name and handles mismatched schemas.
column-splitting-and-parsing
Split a single column into multiple columns based on delimiters, fixed widths, or patterns. Extracts structured data from unstructured text fields.
pivot-and-unpivot-transformation
Convert data between wide and long formats. Pivot transforms rows into columns (aggregating values), while unpivot transforms columns into rows.
duplicate-removal-and-deduplication
Identify and remove duplicate rows based on all columns or specific key columns. Keeps first or last occurrence based on user preference.
null-and-missing-value-handling
Detect, replace, and manage null or missing values in datasets. Options include removing rows, filling with defaults, or using formulas to impute values.
text-transformation-and-formatting
Apply text operations like case conversion (upper, lower, proper), trimming whitespace, and text replacement. Standardizes text data for consistent analysis.
+10 more capabilities