Select

Select operation should be used only when you want to see few specific columns of the DataTable. You can use this operation to select one or more columns using different criteria as per your requirements.

Note that when you use the Select operation on a DataTable, it will generate a child table with only the selected columns.

Let's take a basic example of a DataTable shown below:

In the above table, select operation is applied as shown below:

let fusionDataStore = new FusionCharts.DataStore();
let fusionTable = fusionDataStore.createDataTable(data, schema);
let selectedData = fusionTable.query(FusionCharts.DataStore.Operators.select(['Country', 'Sales']));COPY

The new DataTable after applying select operation is shown below: