Selecting Columns For ImportBack to index page
Switching to Columns tab you can select columns to import data from. If you click on Select all, all data fields will be selected, if you click Deselect all, the selection will be removed from all data fields.
The name and some properties of a selected field can be edited on the right side of the dialog:
The DisplayName of the field can be edited.
Use as Identifier: here can be selected if this field will be used as an Identifier field after importing. This means that it can be used in ID assignment related function (JCIDSYSStructure).
ID: the previously selected ID is displayed again.
IsFormula: if this is set to True, in the grid view (see in Running the Search topic) the appropriate field will be displayed as a molecule formula format, which means that the number after atomic symbols will be displayed in subscript. (This function is not active in the excel worksheet, only in the grid view.)
Type: String, Date Time, Numeric.
In Format category the imported and exported format of data in the cell can be specified. The most important types, which can be selected: General, Number, Currency, Accounting, Date, Time, etc.
Press Import and a progress bar will display how the process is going on.
The selected data will be displayed on the specified worksheet.