SQL in Alteryx

Some of the Tools in Alteryx   offer  similar functionality  of SQL Commands,which are listing below:-


Alteryx Tool             SQL Clause                        Description

	SELECT	Alteryx by default will show all available columns,  using a Select tool, located in the Favorites Toolbox,we can select required columns,change column names and data formats,for example V_String to Int
	WHERE	Using the Filter tool,in the Favorites Toolbox 'Where' conditions can be checked.’T’ side of filter gives conditional matching data and ‘F’ side gives us unmatched data
	GROUP BY	Using a Summarize Tool, located in the Favorites Toolbox ,  Group By functionality can be accomplished
	JOIN	Using Joins tool,Joins can be implemented.By default it gives output in Inner Join fashion.
	CARTESIAN JOIN	Cartesion Join is the Cross Product of 2 Tables. Using an Append FieldsTool, Cartesian join functionality can be easily accomplished
	LEFT JOIN (Also known as LEFT OUTER JOIN)	To achieve Left Join in Alteryx, the data that is output from the center of the Join Tool can be union with the data that is output from the left side of the Join Tool.
	RIGHT JOIN (Also known as RIGHT OUTER JOIN)	To achieve Right Join in Alteryx, the data that is output from the center of the Join Tool can be union with the data that is output from the right side of the Join Tool
	FULL OUTER JOIN	To achieve Full Join in Alteryx, the data that is output from the center of the Join Tool can be union with the data that is output from the right side,left side of the Join Tool
	ORDER BY	Order by functionality can be accomplished using a Sort Tool. Any field can be selected and sorted using this tool, in either ascending or descending order.
	AGGREGATIONS (SUM,MIN,MAX etc)	Using Summarize Tool, any column can be aggregated by choosing the required aggregate option from the Numeric drop-down menu.
	DISTINCT	In Alteryx by using a Unique Tool, return an output with unique values,which is equivalent to  SQL DISTINCT

Thanks Guru's,
Prazval.ks