The Operations Palette

The table below describes the different elements used to create a data flow diagram on the Canvas.

Icon

Description

 

 

Click on this icon in the palette to add a Dataset to the Canvas. See Adding a Dataset.

 

 

Click on this icon in the palette to choose specific Columns and/or build your expression. See Adding Columns.

 

 

Click on this icon in the palette to add a WHERE clause and build your query. See Adding Filter.

 

 

Click on this icon in the palette to add a JOIN operation to your query. See JOIN Operation.

 

 

Click on this icon in the palette to add a UNION operation to your query. See UNION Operation.

 

 

Click on this icon in the palette to add an EXCEPT operation to your query. See EXCEPT Operation.

 

 

Click on this icon in the palette to add an INTERSECT operation to your query. See INTERSECT Operation.

 

 

Publish you flow. See Publishing a Flow.

 

 

Clear your work on the Canvas.

 

 

Delete your flow.