Distinct

Overview

The DISTINCT is a child of Datasources that returns only rows that contain a unique/distinct field value. The DISTINCT is useful for removing data from a Datasource that is not unique based on its source field.

Restrictions:

DISTINCT is case sensitive. You can chain other transforms and manipulate the data further to remove this.

Parent:

Datasources

Children:

None

Widget Attributes

Name	Type	Default	Description	Req
field	string	""	the field name to check distinct values against	✔
enabled	bool	"true"	boolean expression to (en/dis)able the datasource	✔

Examples

(fig. a)

DISTINCT on a DATA datasource

<FML>  
	<!-- We used a DATA datasource but any datasource can be used -->
	<DATA id="distinctArrivals">
		<DISTINCT field="arrivalDayOfWeek"/>
	</DATA>
</FML>

Other Widgets You May Find Useful

• Datasources
• CALC
• PIVOT
• SORT