09-07-2017 01:42 PM - edited 07-23-2021 10:53 AM
This contribution iscompiled entirely from@jdunkerley79's postson adding Custom Formula Functions in our Community Discussion Boards...
"I have updated my Alteryx Formula AddIns based mainly around things I see coming up in the community and also things I find that should be easier. The full function list is at the bottom of this post.
Full details on theaddins can be found on my blog;the addins can be download from GitHub.
Hopefully it will make creating some formulaseasier!
James"
The full function list currently is:
The installation process should be:
- Download the release zip (currentlyhttps://github.com/jdunkerley/AlteryxAddIns/releases/download/v0.5.4/AlteryxOmniBus.v0.5.4.1.zip)
- Extract all the files in it to somewhere you want to keep and run the tools from
- Run Install.bat within this folder (you may need to approve within Windows Defender SmartScreen as well)
- Accept the UAC request
- Reopen Alteryx and the tools should be available.
Hi Matt,
This is super cool. I download the files and followed your instruction. Unfortunately I was not able to install it after the command window showed up and I entered my computer credential. Please kindly advise anything I have done wrong. I really want to install them on my computer.
Or can Alteryx think about ADD THEM TO NEXT RELEASE?
Thank you!
This step is not working "Run Install.bat within this folder (you may need to approve within Windows Defender SmartScreen as well)".
Command window closed right after showed up.
tried several times. all like that.
Cannot use those functions.
Can you please help?
This is awesome, ended up here searching for how to write custom functions. But looks you've made all the ones I was wanting.
It's still a bit of a pain though as need to install these on every users system if want to rerun analysis, makes the work not very transferable. These really should be standard in Alteryx already so don't have to worry about moving data.
Where can I start a petition?
Went through the installation process and verified installation into C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn\, where I proceeded to use the split function in Alteryx and got an 'Unable to load dll: C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn\JDFormulaAddIn.dll'. Searching the community and the internet did not provide a reasoning why? Any help?
Hello,
I copied the DLL and XML files into FormulaAddIn under RuntimeData as I am not the admin. Closed and opened Alteryx. Cannot find the added formulae. Please help!