Trying to compare old version and recent version outputs to test if results are matching?

[Kurohits]

Hi Experts,

Will really appreciate if anyone could help me to automate output comparision which coming out from same workflow. So, I have 2 outputs, one is from older version of workflow and the other is from recent version of same workflow. My task is to compare both the outputs and do certain checks like number of columns is same or not?,  sum totals of dimensions are same or not? Number of values are same or not? there are different testing/comparision I want to do between old output (from older version) and new output (from recent version). 

What would be the best and most feasible way to achieve this task? Anyone have any idea if I should create another workflow to compare 2 outputs or should I can use interface tools to automate this? 

Looking forward to hear from all the experts here in community. 

Thanks in advance !! 

[binuacs]

@Kurohits Are you expecting any changes on these outputs created from the old and new versions of Alteryx? If your logic is the same in your both workflow I don't think there will be any differences. 

[Kurohits]

Hey @binuacs 

Actually what I am trying to achieve is to compare outputs of same workflows with same datasets and business logics. Actually there was some workflows built by another person and then I modified those workflows in order to optimized runtime. Now, what I am looking that to compare outputs of both workflows to check if there are not any differences between 2 outputs. There are bunch of workflows like this which outputs need to be compared. There should be no changes in outputs actually, it;s just we need to check if both outputs are same or not. For that I am looking for best possible way to achieve this so that I can use this solution in future also to compare outputs. 

I hope this clarifies your doubts. 

Looking forward to hear from you. 

[binuacs]

@Kurohits In that case use the join tool to connect your outputs generated from both workflows and do the comparison. You can use all the fields as the keys in the Join tool

[Kurohits]

@binuacs 

There is not only one thing that I need to test. I want to automate this so that others can use this utility workflows to compare and test 

outputs. 

the workflow should be able to test: 

number of columns

sum totals of dimensions 

Number of values in the field etc. 

I want to make sure that I am creating feasible workflow on use automation to achieve this task.

do you have any idea, how to achieve this? 

[binuacs]

@Kurohits can you try the below macro

https://community.alteryx.com/t5/Community-Gallery/Compare-2-datasets/ta-p/1057803