Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Can Alteryx be used fo the comparison of two different datasets?

Highlighted
6 - Meteoroid

Can Alteryx be used fo the comparison of two different datasets?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Of course! Input the data and merge it to start identifying discrepancies.

 

What format is the data in?

Is there a unique identifier for each record that is common between both datasets?

Highlighted
Alteryx
Alteryx

Absolutely, reconciliation is a very popular use case for Alteryx.

 

I recommend bringing the 2 data-sets into Alteryx using the input data tool.  Then join them together so you can compare the data sets side by side. 

 

 

Highlighted
6 - Meteoroid

Thank you NickC for the prompt response. It was really helpful.

 

Are there any learning resources apart from the community interactive lessons that you are aware of?

Highlighted
5 - Atom

Is there any particular use case for reconciliations of two data sets? I would like to see that. Please advise. Thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

You might also want to try our CReW Delta macro.  It is available in the Alteryx Gallery:

 

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

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
5 - Atom

Thank you.

Labels