Data Preparation

Combine or Split Multiple Columns

In this version, you can combine multiple columns into one or split a column into multiple columns.

For more information, see the following topics:

Disclaimer: The below video Information published on non-SAP site is not part of the SAP product documentation. Please read the legal disclaimer for video links before viewing this video.
Date and Time Formatting
In this version, you can import data from an SAP HANA table or view containing columns with the following data types and choose the format to display this data:
HANA Data Type Agile Data Preparation Data Type

DATE

DATE

TIME

TIME

TIMESTAMP

DATETIME

SECONDDATE

DATETIME

Actions on the Column

Edit A Cell

In this version, you can edit the contents of an individual cell if your worksheet contains primary keys.

Edit Cell
Disclaimer: The below video Information published on non-SAP site is not part of the SAP product documentation. Please read the legal disclaimer for video links before viewing this video.
Filter Worksheet on a Column Value

In this version, you can filter a worksheet on a specific column value if your worksheet contains primary keys.

Filter Worksheet By Column Value
Add A Column

In this version, you can add a column if your worksheet contains primary keys.

Disclaimer: The below video Information published on non-SAP site is not part of the SAP product documentation. Please read the legal disclaimer for video links before viewing this video.