Configure the settings of the Analysis tab of the Data Import app to import data from an existing table

Prior to this task:

✔ Data must be loaded.

✔ Data Import app must be opened.

1️⃣ Data Import – Analysis tab ➡ Data source ➡ Select Raw Data Source ➡ select Existing table
2️⃣ Data Import – Analysis tab ➡ Data source ➡ select  [Next]
3️⃣ Data Import – Analysis tab ➡ Load Data ➡ select table
4️⃣ Data Import – Analysis tab ➡ Load Data ➡ select  [Next]
5️⃣ Data Import – Analysis tab ➡ Configure data ➡ select Plate Row Column Features* Annotations*
6️⃣ Data Import – Analysis tab ➡ Configure data ➡ select  [Apply]

Supporting Knowledge

Note: The user can go back to a previous section to modify settings by going to the Data Import – Analysis tab and selecting the  [Previous] button.

*For Features and Annotations addition, select the  [Click to add] option. From the Features/Annotations window, under Available items, select the desired column(s), select  [Add items], then select  [Save].

Note: Multiple features and annotations can be selected simultaneously.

Optionally, from the Features and Annotations windows, the user can mark or unmark all items by selecting the  [Mark All] or [Unmark All] buttons, respectively. Also, the user can add all, remove individual items, or remove all items by selecting the  [Add all],  [Remove items], or  [Remove all] buttons, respectively.

Optionally, from the Data Import – Analysis tab, under the Configure data area, the user can mark data to selected wells and mark points in the analysis for exclusion or inclusion by selecting the  [Exclusion] and [Inclusion] buttons, respectively. To reset the points that have been excluded or included, select the  [Reset] button.

Optionally, from the Visualization tab, the user can use the available toggles for further modifications. From the Data Import – Analysis tab, select  [Visualization]. From the Data Import – Visualization tab, under Visualization settings, the Selected Feature label toggle will be turned on by default. This option enables the user to select the feature’s value and will be displayed as a label in the Plate layout scatter plot. This can be turned off by selecting the  [Selected Feature label] toggle.

Additionally, from the Data Import – Visualization tab, under Show Filter panel, the user can turn on the Filters panel by selecting the [Filter Panel] toggle. This option enables the user to filter out data for further exploration. The selected filters will be applied to the Plate layout visualizations. Select the  [reset filters] button to reset all the active filtering.

Optionally, from the Configuration tab, the user can modify the formatting of the selected features. From the Data Import – Analysis tab, select  [Configuration]. From the Data Import – Configuration tab, under Features format and Decimals, select options to define the numeric formatting of the selected features.