The Smart Load Wizard enables you to create Teradata and Aster tables derived from data stored in an external file on your file system.
- Import Data from External File
- You can enter the path and name for the file to import or click Browse to find a file on your file system. The Input File field is required. The default file type is delimited text. If you choose a Microsoft EXCEL file type, you are shown options for files with .xlsx and .xls extensions.
- Table Column Option
- The Column Labels in First Row check box lets you use the first row of data as the column labels for the new table.
- Drop Table If Max Errors
- The Drop Table If Max Errors Occur check box lets you specify the maximum number of errors required to drop a table.
- Data Scan Option
- When you import data stored in files with .txt and .csv extensions, you can perform a partial scan of the file data during the import of that data to a Teradata table. This option is not available for Microsoft EXCEL files.
- File Data Options
- If you selected the Delimited Text file type, the File Options section enables you to specify the type of column delimiters, character string delimiters, and character encoding the data in the imported file uses. If you specified an EXCEL spreadsheet as the input file and selected either EXCEL (.xlsx) or EXCEL 97-2003 (.xls) as the file type, you can import data from a single worksheet in the file by selecting a worksheet name in Import Worksheet. The Line Separator options enable you to import files that have only LineFeed (LF), as in Unix and Linux, or only Carriage Return (CR) as in Mac OS/X prior to v10.0, or both, as for Windows. The options are:
- Windows OS (CR and LF)
- Prior to Mac OS X v10.0 (CR)
- Unix, Linux, Mac OS X v10.0 and above (LF)
- Controls
- The action controls for the Smart Load Wizard are located at the bottom of the screen and enable you to move back and forward among the Import File, Table Column Data Types, and SQL Preview screens.