Here’s an Alteryx quick tip which might save you a lot of time in the future when using the Select tool.
Have you ever had to tick box after box in Select because there is no obvious way to tick multiple boxes at once?
Well, the good news is you can tick multiple fields simultaneously by delving into the Options Menu in the Select tool.
In the Options – Select submenu, you can tick/untick all the fields.
You can also target a specific group of highlighted fields.
To highlight, left click – drag your cursor over the fields or alternatively Shift – left click.
However, if you want to highlight multiple fields which are not adjacent to each other (see below for an example), you need to use Control – left click, which allows you to highlight individual fields while maintaining previous highlighting.
You can do a few other useful bits in the Select Options menu to save some repetitive manual work.
- adding a prefix or suffix to multiple highlighted fields.
- Changing field type of multiple fields
- Sorting the fields’ order – this applies to the remainder of the workflow; not just the Select tool itself
That’s all. I hope you found this useful!