Acquiring data copied to the clipboard

Text-based data can be copied to the clipboard from a text-based file (for example, from Microsoft Excel) or from a web page.

Table 1: New Dataset dialog options for data copied from the clipboard

Option

Description

Dataset Name

The name of the dataset

Separator

Choose whether data on the clipboard is separated by delimiters or is entered in fixed-width columns. Delimiters are symbols, such as commas, tabs, or spaces, that separate fields in the data source and that will specify columns in the dataset in the application.

Set first row as column names

Select this check box to use the first row of data as column names in the dataset.

Clear this check box to use the default column names ("Column1", "Column2", and so on).

Start of the navigation path Advanced Options Next navigation step Number format End of the navigation path

The format for numeric columns in the dataset

Start of the navigation path Advanced Options Next navigation step Date format End of the navigation path

The format for date columns in the dataset

Start of the navigation path Advanced Options Next navigation step Break Column End of the navigation path

When acquiring data stored as fixed-width columns, analyze the data file and suggest column widths (in characters) for separating data into columns in the dataset.

If the suggested widths aren’t suitable, you can change the widths by entering values separated by commas. For example, if your data is in three columns and the column widths are five, 10, and 15 characters, you would enter 5,10,15 in the Break Column box, and select Apply to see a preview of the resulting dataset.

Start of the navigation path Advanced Options Next navigation step Trim leading spaces End of the navigation path

Select this check box to remove leading and trailing values from numbers and text in the dataset so that column headers do not appear as empty fields. For example, if a "Product" entry has a leading space (" Product"), the space is removed and "Product" appears as the column header.

Note The Microsoft Internet Explorer (IE) web browser has a known issue when copying text to the clipboard. If you encounter this issue, use a different supported browser instead.
  1. Copy text to the clipboard.
  2. On the SAP Lumira Home page, select Acquire Data.
  3. In the Add new dataset dialog, select Copy from Clipboard, and select Next.
    The text you copied is pasted in the dialog.
  4. (Optional) Select Trim Spaces to remove leading and trailing spaces from numbers and text in the dataset.
  5. (Optional) Select Trim Row to remove blank lines from the dataset.
  6. Select Proceed.
    Data from the files is previewed in the Add new dataset dialog.
  7. (Optional) Adjust the dataset options in the dialog as needed.
  8. Select Create.
The Visualize room opens, and you can start building charts and analyzing data. If you want to modify the dataset first, switch to the Prepare room.