community
cancel
Showing results for 
Search instead for 
Did you mean: 

Inspire 2019 | Buzz

Stay up-to-date, connect with peers & share your experience!

Give us Your Best Tips and Tricks - Calling all Tip Meisters for Inspire 2019!

Meteor

If you create a workflow in a new version of Alteryx but need to share it with a user with an old version, you can just open the workflow using an editor like Notepad++ and change the workbook version on the first line. Just make sure you're not using any advanced features not available in older versions...

 

Capture.JPG

Comet

When pulling from a data source that may not be reliably updated, use the test tool to do data validation and workflow events to send you an email after a run with errors. This will allow you to have peace of mind enough to schedule it instead of manually running it to verify that the data is correct.

 

test.PNGemail on error.PNG

Highlighted
Alteryx Certified Partner

Nice reconciliation pattern - pull out non matching records, then non matching fields within records.

Endlessly fettlable, treating complete no matches differently etc, but very handy to have a test on the ultimate output that triggers when any records are output.

Would love to see other people's takes on this - I'm sure there are more elegant ways of doing this.

 

Note - just bumped into @MarqueeCrew in the ginormous Gaylord who told me about his new CReW Delta tool for configuring evaluation equivalence of datasets that I'm going to have a look at later on !

 

ReconciliationTip.PNG