Import from Clipboard or File to Table: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
If you importing from a file, a button enables you to browse for the file. | |||
The file format must be Text and Tab delimited.<br /> | The file format must be Text and Tab delimited.<br /> | ||
The following options are available for you to specify the structure and nature of your import data. | The following options are available for you to specify the structure and nature of your import data. | ||
Row Labels<br /> Import Data contains Row Labels (before column 1 data). | Row Labels<br /> Import Data contains Row Labels (before column 1 data). | ||
Col Labels<br /> Import Data contains Column Labels (before Row 1 data) | Col Labels<br /> Import Data contains Column Labels (before Row 1 data) | ||
Auto Column Type<br /> Auto Column Type will automatically detect, and implement for a column, a special Column Unit type (like Time or Money). | Auto Column Type<br /> Auto Column Type will automatically detect, and implement for a column, a special Column Unit type (like Time or Money). | ||
Append Rows<br /> Import Data will be appended to Existing Rows.<br /> Leave unchecked to remove existing rows before Importing this data.<br /> | Append Rows<br /> Import Data will be appended to Existing Rows.<br /> Leave unchecked to remove existing rows before Importing this data.<br /> | ||
Resize Columns<br /> If the number of columns of data in the Import Data is different to the current Table, then add, or remove columns to suit the incoming data. (Careful - this does not go well with importing Col labels also). | Resize Columns<br /> If the number of columns of data in the Import Data is different to the current Table, then add, or remove columns to suit the incoming data. (Careful - this does not go well with importing Col labels also). | ||
---- | ---- | ||
| Line 30: | Line 20: | ||
<font size="2">idkbase note 10038</font> | <font size="2">idkbase note 10038</font> | ||
[[Category:Table]] | [[Category:Table]] | ||
[[Category:Context Help]] | [[Category:Context Help]] | ||
[[Category: | [[Category:Data/Exchange]] | ||
Latest revision as of 02:40, 13 January 2008
If you importing from a file, a button enables you to browse for the file.
The file format must be Text and Tab delimited.
The following options are available for you to specify the structure and nature of your import data.
Row Labels
Import Data contains Row Labels (before column 1 data).
Col Labels
Import Data contains Column Labels (before Row 1 data)
Auto Column Type
Auto Column Type will automatically detect, and implement for a column, a special Column Unit type (like Time or Money).
Append Rows
Import Data will be appended to Existing Rows.
Leave unchecked to remove existing rows before Importing this data.
Resize Columns
If the number of columns of data in the Import Data is different to the current Table, then add, or remove columns to suit the incoming data. (Careful - this does not go well with importing Col labels also).
idkbase note 10038