Alteryx CReW 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!

44 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
    Replies
    1. Adam have you resolved this? We are seeing the same after upgrading to 2021.2. But noticed it only happens when we deselect the option "Field names in data". Any help would be appreciated.

      Delete
  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
    Replies
    1. Hello, did you find a workaround on your issue ? It seems that Crew macros do
      not work with the new version of Alteryx

      Delete
    2. Also interested in this, running Alteryx 2021.1 x64 and getting the following:

      Runner (8) Tool #2: The external program "SupportingExes\AlteryxRunner.exe" returned an error code: -1073741512

      Delete
    3. I am also having this error while using Runner tool. Does anyone have a solution to fix this ? Thanks

      Delete
    4. I am also experiencing this issue with the latest version of ALTERYX. Has anyone found a solution? It has impacted production processes to the point where I might have to roll back to the previous version.

      Delete
    5. Please try to add "C:\Program Files\Alteryx\bin" into environment variables PATH.

      Delete
    6. Just for information, I'm stll getting the error even after adding "C:\Program Files\Alteryx\bin" into environment variables PATH

      Delete
  21. Hello - wondering if you could help - runner and listrunner were working fine but now are failing on Error - ToolId 3: Internal Error: Unknown InitVar "JupyterTempPath" on any workflow with a Python tool.

    There is a community article (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Internal-Error-Unknown-InitVar-quot-JupyterTempPath-quot/td-p/703119) but this is unresolved.

    I tried downgrading to 2019 without success and can see that Alteryx fixed this previously in release notes.

    Any direction would be very appreciated.

    ReplyDelete
    Replies
    1. No Update on this by Alteryx Community yet you can however use Run Command from Events to execute WFS back to Back!

      Delete
  22. can anyone offer any help when running ListRunner and you get this error message? "Runner (8) Tool #2: The external program "SupportingExes\AlteryxRunner.exe" returned an error code: -1073741512" please help

    ReplyDelete
  23. Please try to add "C:\Program Files\Alteryx\bin" into environment variables PATH.

    ReplyDelete
  24. I can't install the Install.yxwz how can I run it?

    ReplyDelete
  25. Hi Evan, you probable already solved it but if haven't..you won't find 'Install.yxwz' after your download the zip files to your local machine double click on icon called 'Install' it works! wil

    ReplyDelete
  26. Hi, Can we have CRew_Runner ignore "Conversion Error"?
    In other words I want it to let a Workflow Run as Sucessfull if there are conversion errors on "Select" tools, and only consider a Failure if we have "Error".

    ReplyDelete
    Replies
    1. Hi, I discovered a bug.
      Usually the CRew_Runner would not consider a data conversion error as an error. I force tested date conversion and the Successfull workflow outputs to Success output, but if I force a v_wstring to v_string conversion error the Sucessfull workflow outputs to Fail and also the CRew_Runner stops collecting logs that really is anoying.

      Delete
  27. Following upgrade to 2021.4.xxx, my CReW macros still showed installed on the ribbon from my prior installation, but all of the old workflows with CReW macros when opened said "This workflow references macros (Crew\Macros\.yxmc) that are missing or inaccessable. Saving this workflow will permanently disable these tools".

    I've been trying to figure out how to fix this for weeks. One of the things I was going to try was uninstalling and reinstalling. Has anyone noticed that the "Uninstall" feature in the Install.yxwz does nothing? It doesn't remove the tools from your ribbon, and it doesn't delete the .ini files, and I don't know what else should happen to uninstall. I deleted the ini files from
    C:\ProgramData\Alteryx\DataProducts\AddOnData\Macros

    Now the CReW tools in the ribbon have disappeared. I'm not sure if that is really all the uninstall feature was intended to do, and deleting the folder they are stored in makes it "complete". But now I am going to try installing them from scratch, or just pointing User settings>Macros to the folder I installed them from.

    I know that isn't the "correct" way anymore. I just need to be able to open my old workflows without errors because I will be wrecked if I have to rebuild these complicated workflows originally built by someone else from scratch.

    ReplyDelete
  28. Okay, what I have found is that is you go to your Macros folder, then Create a sub folder and name it CREW Macros, that this is the best way to have Alteryx Auto Populate...
    Alteryx/Macros/Crew Macros

    ReplyDelete
  29. I see the runner macros accept a app (yxwz) format, but is there a way to follow it with the app file with a value (yxwv) file like you can in command line?

    ReplyDelete
  30. Hello, I've hit a problem testing Runner macro in 2023.1 that were OK in 2021.4. The standard runner reports "ConvError: Runner (1): Tool #2: The field "Field_1" was truncated in record #133". It is being caused by some messages I generate that exceed 254 characters. I can truncate the messages but would prefer to allow a longer field.

    ReplyDelete
    Replies
    1. Hello Homer, regarding your previous comment, there is currently no option to use a YXWV file like in AlteryxEngineCMD.exe as far as I know, I posted an idea about this few months ago on Alteryx Community, you can read it here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Enhancements-and-Documentation-for-AlteryxRunner-exe-Used-by/idi-p/1175434. As for the problem you mentioned above, I would recommend that you use the wizard I posted here, which makes the installation process of Runner easier and automatically increases the field length: https://community.alteryx.com/t5/Community-Gallery/Alteryx-Runner-Standalone-Macro-Installation/ta-p/1175156

      Delete
  31. So I have found if you've used Install.yxwz in the past and created workflows, and then need to reinstall Alteryx and the CReW macro pack you should NOT just link Alteryx back to any prior extracted version of the CReW macro folder on your computer or elsewhere.

    You'll get that dreaded Alteryx "can't find the reference to tool XXX, if you save this workflow you will remove the reference" (or something close) that used to happen every time on Alteryx upgrade/reinstall and CReW reinstall, and would require workflow XML edits to fix the CReW macro folder reference to get them working again.

    If you do the full install steps again above then, or at least just re-run your old Install.yxwz those old authored workflows created with the Install.yxwz method originally, work again. If you have really old workflows from before the Install.yxwz that just linked to a CReW macro folder, you will still need to do XML edits.

    It looks like when you've used Install.yxwz the XML contains only the tool name, not a full reference to the CReW macro folder location, that used to constantly trip up Alteryx after reinstallations for some reason.

    I feel like Alteryx in general, and CReW Macro pack specifically writes basic instructions for the "happy path - first time through" but doesn't have good guidance for when things go wrong how to fix them.

    ReplyDelete
  32. May someone help about the install file? After extract and run the Install.yxwz

    An error message appears:
    DbFileOutput (7): Error creating the file " C:\ProgramData\Alteryx\DataProducts\AddOnData\Macros\CReW.ini ": Access is denied. (5)
    DbFileOutput (8): Error creating the file " C:\ProgramData\Alteryx\DataProducts\AddOnData\Samples\CReW.ini ": Access is denied. (5)
    DbFileOutput (24): Error creating the file " C:\ProgramData\Alteryx\DataProducts\AddOnData\Macros\CReWTest.ini ": Access is denied. (5)

    I've searched that directory and all 3 .ini are in the folders but the errors are keeping showing. What to fix that issue?

    ReplyDelete