These are two of the options that you can use for data wrangling when you import a file for a story in SAP Analytics Cloud, according to the SAP Help Portal1. Data wrangling is the process of cleaning, structuring, and enriching raw data into a desired format for better decision making in less time2.
The custom expression editor is a tool that allows you to create or edit formulas and expressions for your data columns3. You can access the custom expression editor by clicking on the formula icon in the builder panel or by double-clicking on a column header in the data view3. The custom expression editor provides a list of functions and operators that you can use to manipulate your data, such as arithmetic, logical, string, date, and aggregation functions3. You can also use the custom expression editor to create calculated columns or measure-based dimensions from your existing columns3.
The transform bar is a tool that allows you to apply various transformations to your data columns, such as renaming, reordering, grouping, splitting, merging, or deleting columns4. You can access the transform bar by clicking on the transform icon in the builder panel or by right-clicking on a column header in the data view4. The transform bar provides a list of actions that you can use to modify your data structure, such as move left, move right, group by, split by delimiter, merge columns, or delete column4. You can also use the transform bar to change the data type or format of your columns, such as text, number, date, currency, or percentage4.
