Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

asaditm
6 - Meteoroid

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

6 REPLIES 6
CharlieS
17 - Castor
17 - Castor

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?

NickC
Alteryx Alumni (Retired)

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. 

 

 

asaditm
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?

Mano
5 - Atom

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

MarqueeCrew
20 - Arcturus
20 - Arcturus

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 restart. Order shall return.
Please Subscribe to my youTube channel.
Mano
5 - Atom

Thank you.

Labels