You can acquire data from one or multiple Microsoft Excel workbooks. You choose which rows and columns to acquire. You can also acquire data from cross tables.
|
Option |
Description |
|---|---|
|
Dataset Name |
Enter a name for the new dataset. |
|
File(s) |
Select the Excel workbooks that will be the data source for the new dataset. |
|
Sheet |
When an Excel workbook contains multiple worksheets, select the worksheet to acquire for the dataset. |
|
Append all sheets |
Select this check box to add all worksheets in the workbook to the dataset. Common columns are appended, and different columns are added as new columns. |
|
Set first row as column names |
Select this check box to set the first row values in the worksheet as column names in the dataset. |
|
Table Header Type |
Select Standard Table (No Transformations) or Cross Table. |
|
Select All |
Select this check box to add all columns in the worksheet to the dataset. |
|
Show record count |
Select this check box to show the number of columns and the number of rows in the dataset. |
|
|
Select this check box to display hidden worksheet columns as column headers in the dataset. |
|
|
Select this check box to display hidden worksheet rows in the dataset. |
|
|
Select this check box to highlight merged worksheet cells in the dataset. |
|
|
When a worksheet contains one or more named ranges, select the range to apply to columns acquired for the dataset. A dataset is restricted to the columns defined in this range. |
|
|
For cross tables, specify the number of columns to use for the left header. |
|
|
Specify the number of rows to use for the top header. |