Alteryx - Format Numbers as Text

Sometimes you just want to output a numeric field in a specific text format for easier user readability. You can use a combination of the Formula Tool and the ToString function to make it happen!
Help Guide for ToString Function: help.alteryx.c...
Help Guide for DateTime Function: help.alteryx.c...
#NPT #Alteryx #Formatting

[@EliteBestGamers]

Nathan can you please teach us how to add optional fields linked to SQL procedures in APP tools? There is no knowledge on that matter in the internet. Please!

[@Matt-gm4pi]

Hey Nathan!
Your videos have been incredibly helpful as research when constructing my own workflows.
Can you demonstrate how to create a dynamic folder directory using Alteryx? Where I can then output files so that the numerous outputs are placed in an organized folder structure.
The structure would be Region -> Project Names per region -> PDF files (output from BLOB tool).
I think I have the BLOB output configured to be dynamic, using the "Modify File Name by Replacing Entire Path with Field", so we should be okay here. But I'm a bit puzzled when it comes to creating a dynamic directory for files. Any insight is appreciated! Cheers!

[@Matt-gm4pi]

Hi Nathan,
I was able to solve this by configuring a render tool to take a dynamic file path from a field.
For whatever reason, the render tool will create a directory if it does not already exist. This has been a fair workaround for now.
Cheers!

[@Matt-gm4pi]

You may also use XCOPY batch command through the RUN tool!