Can Alteryx be used fo the comparison of two different datasets?
Solved! Go to Solution.
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?
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.
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?
Is there any particular use case for reconciliations of two data sets? I would like to see that. Please advise. Thanks
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
Thank you.