Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need assistance to creat a workflow in Alteryx

ibrahim_khan
5 - Atom

Hi,

 

I am reaching out to people in Bangalore who can assist me with creating a workflow for reconciliation of two files that should run on a daily basis. 

it would be helpful if can get some assistance. Please feel free to reach out to me so we can discuss more. Also feel free to free to message me. 

thank you. 

1 REPLY 1
jrlindem
11 - Bolide

Hey there, not in Bangalore, but figured i'd offer some high-level advice.  There are many things you can do to compare two files.  Obviously in order to get them into your workflow and in a state that can be compared, you'll need to input them and then join (or Union) them.

From there, techniques like counting rows, summing numeric data columns, counting columns, concatenating fields and comparing them side-by-side, or even comparing key fields side-by-side are all valid data-quality checks that can be done to different datasets.  A lot of these approaches us base tools, like the Summarize Tool along with the Formula Tool.

 

I hope that gets you started.  If you can provide some sample data, I'm sure I or others from the community would be happy to build out a sample workflow to show.  Please also include what kinds of comparisons you'd need to have occur.

 

Cheers,

Jay

Labels
Top Solution Authors