Data set manipulation steps
-
Add column: add new column to your data set.
-
Duplicate column: copy column into a new column.
-
Delete column(s): remove column fro your data set.
-
Rename column: change name of a column.
-
Reorder columns: change the ordering of columns within the data set.
-
Merge columns: merge values from multiple columns into a single column.
-
Split column: split column based on a delimiter.
-
Filter rows based on formula: keep or remove rows based on result of a formula.
-
Sort: sort data based on selected key columns.
-
Lookup: merge your dataset with another based on key columns.
-
Calculate formula: calculate formula and write result to selected column.