Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
CReW Delta Macro (Beta version)
Macros Uploaded by 20 - Arcturus on 04-06-2022 Downloaded 574 times
  • ACE
  • Macros
  • Prep and Blend
    • Download
    Post Comment

    Description

    A tool to see where the differences are from Expected to Actual data.

    Attachments
    CReW+Delta+(Alpha).yxzp
    Comments
    Kenda
    16 - Nebula
    16 - Nebula
    ‎04-06-2022 07:33 PM

    I like this! A step up from one of my favorites - CReW Expect Equal 

    barbosaus
    8 - Asteroid
    ‎12-09-2022 08:21 PM

    is it working? 

    0 Likes
    Kenda
    16 - Nebula
    16 - Nebula
    ‎12-27-2022 06:37 AM

    So far no issues here @barbosaus! 

    0 Likes
    thompo511
    7 - Meteor
    ‎04-21-2023 12:24 AM

    Hi @MarqueeCrew & @barbosaus ,

     

    Firstly hope you are well!

     

    Secondly, I really love this macro but I'm having some difficulty with the output in instances where a mismatch occurs. Would it be possible to get some help in changing the recordID to a unique identifier via a formula tool? This would hopefully isolate the mismatch instead of skewing all the further results after the mismatch occurs.

     

    Please let me know if this is something you could help with.

     

    Thanks 

    0 Likes
    barbosaus
    8 - Asteroid
    ‎05-01-2023 09:05 PM

    @Kenda What is the Alteryx Version I should have to run ?

    0 Likes
    Kenda
    16 - Nebula
    16 - Nebula
    ‎05-03-2023 05:18 AM

    As @MarqueeCrew was the one who built this, I would defer to him @barbosaus, but I am running on 22.3 with no issues 

    0 Likes
    MarqueeCrew
    20 - Arcturus
    20 - Arcturus
    ‎05-03-2023 05:56 AM

    If you open the yxmd with notepad, the version number is present as 2018.2. You can modify that number backwards to your actual version.  It likely is safe at 10.0. 

    cheers

    0 Likes
    barbosaus
    8 - Asteroid
    ‎05-15-2023 05:42 PM

    thanks guys, because I was in doubt about how to run it in my current version. it was not working

    0 Likes