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:

Order Date Country Sales Quantity Shipping Cost
1/22/2011 Australia 59.724 6 27.43
1/22/2011 United States 125.248 3 3.64
1/22/2011 Australia 6.318 1 1.77
1/24/2011 Australia 110.808 3 9.92
1/24/2011 United States 40.08 6 4.31
1/24/2011 India 59.25 5 4.27
1/24/2011 United States 5.94 3 0.95
1/26/2011 India 79.38 3 13.82
1/26/2011 India 342.51 7 13.22

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']));

The new DataTable after applying select operation is shown below:

Country Sales
Australia 59.724
United States 125.248
Australia 6.318
Australia 110.808
United States 40.08
India 59.25
United States 5.94
India 79.38
India 342.51