Halloween 2025: Alteryx or Treat Tip

[AlteryxMatt]

Greetings from the Halloween 2025 event blog! 

Share one Designer “trick” (time-saver, regex, macro) or one “treat” (a tiny sample data file or macro) in a single reply to this thread...if you dare!

[the_data_guy]

My recent favorite trick since I started using Alteryx Co-Pilot is asking Co-Pilot to document my entire workflow (event the big ones) and like that, Co-Pilot puts out a detailed explanation of all the nodes and into relevant sections.  I can now just copy that info and use in my external documentation for posterity and SOX governance purposes.  Saves so much time!  

[JoshuaB]

Would love to see an example of this @SPetrie Seen this done a bit but definitely a good move

[mkeiffer]

I thought I would share one more tip and trick that I like to use.

If you need to remove leading and trailing whitespace from a String field, you can accomplish this by simply using the Trim function and specifying the field name to trim.  When you use the TRIM function without specifying a specific character to trim away will automatically trim away both leading and trailing whitespace from a String field.  Example - Trim(address).

I will sometimes use a Formula tool or a Multi-Field Formula Tool with the TRIM function as opposed to using the Data Cleanse Tool to eliminate leading or trailing whitespace. 

[SPetrie]

@JoshuaB This is a very quick and dirty example, but I hope it helps. I included most of the interface tools to give the broadest examples I could think of. 

I renamed all the tools using their Annotations tab to make them easier to reference. I can manually add a value in the Workflow Config screen, and it will be used in the running of the flow when I need to test the macro.