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

Question

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 !!

binu_acs · Answer

@Kurohits can you try the below macro

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

Kurohits · Answer

@binu_acs

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?

binu_acs · Answer

@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