Tool to compare 2 data sets

[SeanAdams]

Hi all,

One if the most common data-investigation tasks we have to do is comparing 2 data-sets.   This may be making sure the columns are the same, field-name match, or even looking at row data.   I think that this would be a tremendous addition to the core toolset.   I've made a fairly good start on it, and am more than happy if you want to take this and extend or add to it (i give this freely with no claim on the work).

Very very happy to work with the team to build this out if it's useful

Cheers

Sean

Compare2SetsV2.yxmc

[shotofsean]

Thanks!

I can put the unique Key into the first field no problem. But would you
kindly elaborate on "take off the row-ID process" please?

[shotofsean]

Tremendous work Sean.

Quick question.

Am I right in thinking that the changes in the row data are identifiable via the Row ID (which is an integer referring to the row number in the left data set) ?

If so, is there are way to replace this identifier or key with a key within the original data set, such as a customer ID number or a project ID number within your macro?

Thanks again.

[SeanAdams]

Absolutely - you could change this fairly easily by making sure that the key you want to use is the first field in data set, and then take off the row-ID process.   that should give you the outcome you're looking for.

[SeanAdams]

Hey @shotofsean

I'm working with @TaraM to get a blog published on this tool - hopefully that should help you with your questions.   Give me a few days, and hopefully we can get this out.

Thanks for the interest

Sean

[j-f]

Hi Sean,

I'm really interested to see the outcome of this.  Have you got a link to the blog?

Kind regards

Jackie

[sethuprc]

Hi, I am new to Alteryx and I have 2 set of data to compare and data looks like below

Input 1

ID	Qty	Product	Price	FileName
ABC	50	Chair	12.58	D1
DEF	100	Toys	17.53	D1
ABC	25	Chair	12.58	D1

Input 2

ID	Qty	Product	Price	FileName
ABC	-50	Chair	12.58	D2
DEF	-100	Toys	17.53	D2
ABC	-15	Chair	12.57	D2
ABC	-30	Chair	12.58	D2

Output

ID	Qty	Product	Price	FileName
ABC	50	Chair	12.58	D1
ABC	25	Chair	12.58	D1
ABC	-50	Chair	12.58	D2
ABC	-15	Chair	12.57	D2
ABC	-30	Chair	12.58	D2
	-20	Product Match	Price Mismatch in D2
DEF	100	Toys	17.53	D1
DEF	-100	Toys_B	17.53	D2
	0	Product MisMatch	Price Match

There is no unique field to join. it is kind of probable matches by grouping and identify what is the difference in sum of qty or mismatch in product and price. Any help would be appreciated 

[Joe_Lipski]

I think @MarqueeCrew's Delta Macro might do what you're looking for:

https://gallery.alteryx.com/#!app/CReW-Delta--Alpha-/5b41141b826fd3116445fee8