This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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...
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.
An R trick for easily and efficiently applying an aggregate function to every row in a dataset, grouped by a given column, and capturing multiple rows of data generated by said function. This was demonstrated in the answer to this question.
I think this feature was introduced in 11.7. When I am building a long workflow that takes a while to run, perhaps takes a long time to run a query in a database, you can instead let it run once. Then go to the output window. Copy all records with headers. Ctrl+N then (Ctrl+v or right click paste). This will create a text input with the most recent result from your other workflow. I do this to cut down on run times for testing. When I am done I just add the segment of workflow from the current canvas which runs super fast to the one with the live database connections to save lots of time.
TIP: Take any data on the clip board and paste it to the canvas and it will create a text input for you with your data in it.