Import from Clipboard or File to Table: Difference between revisions

From Planimate Knowledge Base
Jump to navigation Jump to search
m (1 revision(s))
No edit summary
Line 14: Line 14:




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).




Line 25: Line 25:
</font>
</font>
----
----
<font size="2">idkbase note 10038</font>
[[Category:Data/Import]]
[[Category:Data/Import]]
[[Category:Table]]
[[Category:Table]]
[[Category:Context Help]]
[[Category:Context Help]]
<font size="2">idkbase note 10038</font>
[[Category:Clipboard]]

Revision as of 11:20, 11 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