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:

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

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');
  • Apply the greater filter on Quantity column.
var filter2 = FusionCharts.DataStore.Operators.greater('Quantity', 3);

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

The new DataTable after applying pipe operation is shown below:

Order Date Country Sales Quantity Shipping Cost
1/24/2011 India 59.25 5 4.27
1/26/2011 India 342.51 7 13.22