Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.
StephaneP
Alteryx
Alteryx

Yippee, the new workflow comparison functionality is live since 2021.3!! You can now identify which changes have been made between two versions of a workflow either because you forgot (YES your holidays were amazing…) or because you work with several people on the same workflow.

StephaneP_0-1635625281254.png

 

There is a new menu option here: Options> Advanced Options> Compare Workflows

 

StephaneP_1-1635625281329.png

 

First thing to know, in this 2021.3 release you can only compare workflows that are accessible through a file explorer OR that are already open within the Designer. If you want to compare two workflows on Alteryx Server you first have to download them onto your machine.

 

The popup will ask you to select the two workflows you want to compare:

 

StephaneP_18-1635626376932.png

 

Browse in your computer or select one in the drop down list that is already open. The comparison can begin as it opens the two workflows on top each other with new strange orange highlighting.

 

StephaneP_19-1635626468848.png

 

Is this the new Orange Halloween Designer disguise?

StephaneP_4-1635625281786.png

 

No, no. Not this year.

 

Before explaining the meaning, let’s take a step back and ask this simple question:“When you are talking about graphical workflow, how to highlight changes in a simple way?”

 

In fact, when I want to compare two workflows, I have two main questions:

 

1. Where are the modifications?

Not always easy to find when the workflow is big.

 

StephaneP_5-1635625281949.png

 

2. Which kinds of modification are there?

Move, delete, add, update…

 

Answering those two questions is the objective of this visual comparison functionality.

 

Important note: Comparison is based on the unique Tool ID.

 

StephaneP_6-1635625281954.png      StephaneP_7-1635625281964.png

 

It means that you can rename a tool between two versions and the comparator will see it at the same tool. But the same Join tool deleted, then created again (with a different ID) and placed at the same position with same configuration will be considered as a new addition.

 

1. Where are the modifications?

 

Easy: Between the orange brackets

 

StephaneP_8-1635625281979.png

 

In this example it means that something has changed between those two tools. It can be just a simple tool addition or a full branch. Important note: it also means in this example that the two tools wearing the brackets are present in both versions.

 

StephaneP_9-1635625281981.png Output orange bracket: At least one modification has been made upstream of this tool. The output connection(s) have been changed: connection to a new tool, deletion of connection, etc.
StephaneP_10-1635625281984.png Input orange bracket: At least one modification have been made downstream of this tool. The input connection(s) have been changed: addition or suppression.

 

 

2. Which kinds of modifications are there?

 

StephaneP_11-1635625281988.png Full orange square: Depending on which workflow, this tool has been removed or added.
StephaneP_12-1635625281990.png

Hash orange square: Only the tool configuration has changed.

 

 Note: Modification and positioning information are cumulative, meaning a tool can be moved and updated.

                                                    

3. Examples

Let's analyse the comparison result between V1 (top image) and V2 (bottom image).

 

Example 1: Input tool has been updated. Indeed, we see that the path has been switched from relative to absolute.

 

StephaneP_13-1635625282216.png

 

Example 2: Summarize tool has been updated. Indeed, the Product Group By has been removed.

 

StephaneP_14-1635625282450.png

 

Example 3: Data Cleansing tool has been removed. Indeed, we see that tool within a full orange square in V1, meaning that it is not anymore in V2.

 

StephaneP_15-1635625282656.png

 

Example 4: Sort tool has been added. Indeed, we see that it is within a full orange square in V2, meaning that it is not in V1. So this is a creation.

 

StephaneP_16-1635625282860.png

 

Warning: To identify addition and deletion you have to watch both workflows or you can miss something.

 

How can I be sure I haven’t missed a modification?

You are right, on complex workflows you can miss a highlight. Good news, every graphical change is also listed in the comparison log. So you can check it row by row.

 

StephaneP_17-1635626204691.png

 

Enjoy!!

 

 

Banner image by geralt

 

Comments