PATH | Alteryx Tips – Three tips to use the SELECT tool efficiently

Posted on Posted in dicas alteryx

The Select tool can be used for so much more than just selecting and renaming fields! Save time during development by leveraging all of its options.

Select tool functionality can also be applied to other tools such as the Join tool.

Tip 1: Forget All Missing Fields

The Select tool remembers fields that used to be included in the data but are now missing because they were removed upstream. This is a useful feature when building workflows to help you trouble shoot to make sure all data flows through. To clean this up, use the “Forget all Missing Fields” option in the select tool.

 

Tip 2: Unknown Fields

The Select tool (and other tools with select functionality) have a row labeled *Unknown at the bottom of the list of fields.

With this row checked, all new fields from upstream are passed through.

Unchecking the row *Unknown stops any new fields from being included downstream. This is useful if you want to ignore changes in incoming data and want to ensure a consistent output.

 

Tip 3: Grouping Selected Fields

You can sort by selected fields only by clicking on the space above the select fields column:

That´s it! Now you know how to use the SELECT tool efficiently!