.. _`Table`:

.. _`org.sysess.sympathy.data.table.importtable`:

Table
`````

.. image:: import_table.svg
   :width: 48


Import data from a datasource in table format




Documentation
:::::::::::::

Imports data from a wide selection of formats (CSV, HDF5, Parquet, XLSX, Matlab, etc.).
The format of the data is automatically detected, but for proper functionality the node might need
to be configured. The data is imported as the Table datatype which can be used by the majority of
the nodes in Sympathy.

File format plugins
===================
This node uses plugins, with each plugin supporting one or more file formats.
The plugins have their own configurations which are reached by choosing a
plugin in the configuration GUI. Please refer to the documentation for each
plugin (listed below) for details.


The node has an auto configuration which uses a validity check in the plugins
to detect and choose the proper plugin for the considered datasource. When
the node is executed in the auto mode the default settings for the plugins
will be used.


URL datasource
==============

If input datasource is a URL resource, the node will download it to a
temporary file before importing it.

If the URL resource contains credential variables, these will be entered
as part of the URL. See
:ref:`Credentials Preferences<preferences_credentials>` for more info.


Definition
::::::::::


Input ports
===========

    **Input datasource**
        | Type: datasource
        | Description: Datasource configured to point at the location of the data

Output ports
============

    **port1**
        | Type: table
        | Description: Imported Table



Configuration
=============

    **Importer** (active_importer)
        Select data format importer

    **Action on import failure** (fail_strategy)
        Decide how failure to import a file should be handled.



Plugins
=======

* :ref:`plugin_tabledataimporterbase`




Related nodes
=============

* :ref:`org.sysess.sympathy.data.table.importtablemultiple`

* :ref:`org.sysess.sympathy.export.exporttables`




Examples
========





The node can be found in:

* :download:`Car data </Examples/Sympathy for Data/Misc/Cardata workflow.syx>`

* :download:`Types.syx </Examples/Sympathy for Data/Misc/Types.syx>`

* :download:`Table2Text.syx </Examples/Sympathy for Data/Data Processing/Convert/Table2Text.syx>`

* :download:`Html.syx </Examples/Sympathy for Data/Visual/Html/Html.syx>`

* :download:`FigureExternalConfig.syx </Examples/Sympathy for Data/Visual/Figure/FigureExternalConfig.syx>`

* :download:`UpdateExcelReport.syx </Examples/Sympathy for Data/InputOutputGenerate/UpdateExcelReport.syx>`

* :download:`audio_processing.syx </Examples/Time Series/audio_processing.syx>`




Implementation
==============

.. automodule:: node_import_table
    :noindex:

.. class:: ImportTable
    :noindex: