Pages

Macros


Available for download at


NOTE: You will require Alteryx 10.0 or later to use this macro pack.

Installation Instructions


  1. Download the zip file above
  2. Extract it to a location on your machine where you want to keep the macros.  (Not in the Program Files/Alteryx folder or an existing Macros folder)
  3. Run Install.yxwz

Community Supported


These macros are not an official Alteryx release and as such they have not been through the full testing process that tools in the product have.  Some of them are prototypes and experimental, but that is some of what makes them so fun.  

If you find an issue let me know either in the comments below or drop me personally a note and I'll take a look, or if you can see how to fix it yourself then even better!

22 comments:

  1. How do debug errors in list runner?

    ReplyDelete
  2. You say not to save them in the "(Not in the Program Files/Alteryx folder or an existing Macros folder)". Do you have a recommendation/suggestion where you believe is a good location?

    ReplyDelete
    Replies
    1. Mine are in C:\CReWMacros but "C:\Users\ariley\Documents\CReWMacros" might be better depending how locked down your machine is.

      Delete
  3. Does this work on trial version of Alteryx? I am getting an error saying "workflow contains unlicensed tool"

    ReplyDelete
  4. Hi,

    my Crew macros workflow is failing if i schedule it.

    ReplyDelete
  5. Hi, I love your add totals macro but it's not including new columns automatically.
    How to modify it to get new month column selected to calculate row total?

    ReplyDelete
  6. We are seeing an error running workflows containing Python tools via List Runner:
    Error: Unknown InitVar "IsDebugAnalyticApp". It is a known bug. See https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-tool-in-combination-with-CReW-list-runner/td-p/450294. Any solutions on the horizon or recommendations? Thnaks, Bob

    ReplyDelete
  7. Hi, I changed the folder of this macro, now it doesn't open, I tried to move to the original folder and uninstall there, and on new folder, try to install again fail. Is there anyway I can make it work again?

    ReplyDelete
  8. For installing CREW macro in Alteryx Server do we need to have stop the server and then install it or we can directly install it?

    ReplyDelete
  9. Great stuff Adam!

    The Field Sort tool does not retain each field's data type--they all become V_WString. Can you modify the macro so that it automatically reflects the original type?

    ReplyDelete
  10. Hi Adam,

    What license are these macros released under?

    ReplyDelete
  11. There is a documentation of components? I would like learn to use each ones thems

    ReplyDelete
  12. Does this work on trial version of Alteryx? I am getting an error saying "workflow contains unlicensed tool"

    ReplyDelete
  13. Does the Crew Runner have a record limit? Seems like I am getting cut off from the results messages at line 145 right in the run command.

    ReplyDelete
  14. Hi, there is an error in dynamic metadata tool (by the way very usefull in some cases). Path "From Rows detour" looses a scale in FixedDecimal. Please fix this.

    ReplyDelete
  15. Does it explain anywhere what the Crew macros do? Maybe I'm being dense but I can't find much to explain the high-level for someone new to alteryx.

    ReplyDelete
  16. Can you please upload the hash of the files or the ZIP? Bit risky to download them without knowing if they have been compromised.

    ReplyDelete
  17. How I execute multiple workflow sequentially, if one workflow have any error then next workflow will not run

    ReplyDelete
  18. Hi Adam Riley,
    We have been using CReW macros from the last 3 years on Alteryx 2018.4 and 2019.4 without any problem. We are using these on chained app on Alteryx gallery to run multiple Alteryx workflows. We have recently upgraded to 2021.1 on our preprod server and since then we are unable to use CReW macros. We are getting below error:

    Configurable_ConditionalRunner (xxx): Record #1: Conditional Runner (xx): Tool #xx: Record #1: Tool #2: Tool #2: The external program "SupportingExes\AlteryxRunner.exe" returned an error code: -1073741511
    Configurable_ConditionalRunner (xxx): Record #1: Conditional Runner (xx): Tool #xx: The output connection "Output3" was not valid
    Configurable_ConditionalRunner (xxx): The output connection "Complete" was not valid

    On further investigation, we found that the error is coming in the command tool used in Crew_Runner macro. The error is as follows - As I understand, path: C:\Alteryx_temp_Logs\Engine is nothing but the path defined while configuring Alteryx server settings and Engine_5972_f9f8d81c877a400ca29cb5c5bce26004_ is nothing but the temp folder created by Alteryx each time when we open a workflow in Alteryx Designer. We have not touched the CREW macros and the same setting was working fine with Alteryx Server 2019.4, so wondering why it is not working with Alteryx Server 2021.1? Would appreciate if you can point us in right direction.

    Error: Run Command (2): File not found "C:\Alteryx_temp_Logs\Engine\Engine_5972_f9f8d81c877a400ca29cb5c5bce26004_\out.txt"

    ReplyDelete
    Replies
    1. Hi Siddharth, Can you share sample workflow for your crew macros to check the error?

      Delete
  19. I recently upgrade our server and my PC to 2020.2 and when I try to use the Wildcard XLSX macro I am getting this following error. "Error: Wildcard XLSX Input (94): Detour tools in macros must terminate within that macro"... I have opened up the macro manually and I see nothing wrong with it. Any suggestions- doing a workaround would be a pain.

    ReplyDelete
  20. I tried to use the CReW macros on Alteryx Designer 2021.1.4 -> opened an example workflow but it doesn't seem to work. I receive the following error: "List Runner (1) Tool #3: Iteration #1: Tool #5: Record #1: Tool #2: Tool #2: The external program "SupportingExes\AlteryxRunner.exe" returned an error code: -1073741512" Could someone help me out?

    ReplyDelete