Join Operations using Pipe

Pipe is an operation which lets you run two or more data operations in a sequence. Instead of applying multiple filters one by one to a DataTable which creates multiple DataTable(s), you can combine them in one single step using pipe and apply to the DataTable. This creates only one DataTable.

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

Now, let's add some operations to the above table:

• Apply the equals filter on Country column.

var filter1 = FusionCharts.DataStore.Operators.equals('Country', 'India');COPY

• Apply the greater filter on Quantity column.

var filter2 = FusionCharts.DataStore.Operators.greater('Quantity', 3);COPY

Once you are done with the above steps, apply pipe operation to run the above steps in sequence.

The pipe operation is applied as shown below:

filter1 = FusionCharts.DataStore.Operators.equals('Country', 'India');
filter2 = FusionCharts.DataStore.Operators.greater('Quantity', 3);
pipeDataTable = fusionTable.query(FusionCharts.DataStore.Operators.pipe(filter1, filter2));COPY

The new DataTable after applying pipe operation is shown below: