Preparation Tools

Blue tools are designed to assist the data processing process for analysis. Instead of worrying about SQL encoding in our Excel formulas you only need to drag and drop tools within the workflow.

Filter

Basically, the filter allows you to split your data into two streams: records that satisfy your speech (True) and records that do not (False). You can access both broadcasts afterward, but as a good practice, it is recommended to construct a sentence in such a way that the response you want will be on the “true” side.

Select Tool

It looks like a filter in a sense, once it re-runs within the columns, however, instead of a dialog that may result in a true or false answer, here you can select and edit your fields. It is useful to rename, resize, resize data, and more.         

Formula Tool

Allows you to create or update fields in different ways. For example, we used formulas to calculate the number of columns in a file, to create a new column with a total of two more columns.

Multi-Line Formula Tool

This tool allows you to create or update lines in one field. Today we have used it to fill in the “blank” values ​​in a column with US regions, making regions appear in every row.

Join Tools

These are the tools used to integrate different data sources.

Union Tool

Used to combine two or more data streams in the same format (same columns), but different data. The result will be a file with all your information both streaming together.

Alteryx was recognized as a leader in Gartner’s 2018 magic quadrant for data science and machine learning platforms Gartner specifically recognized alteryx as the leader with the highest ability to execute on its vision alteryx. Alteryx’s easy to use solutions address the needs of a wide range of problem solvers from citizen data scientists to highly trained business analysts, the alteryx platform offers customers both a code-free and code-friendly approach, hundreds of automation building blocks and the ability to integrate with enterprise applications and robotic process automation or rpa to automate machine learning pipelines and business processes.,