****Please help******* I attached my Alteryx Workflow and the Excel Speadsheet
Orange colored tabs indicate data that came from Cognos (SAP)
I would like to compare two files for Monthly Reconciliation. There are two systems COGNOS (SAP) and (G Treasury). The Data starting in column BM is what I have manually entered and added formulas, respectively. The Purpose is to get data in a format to allow comparison with GT data.
*GL Transaction – Indicates Cash entries from GTreasury that we reconcile completion and accuracy with SAP (via interface and manual journal entries)
*GL Processing – Indicates financial entries from GT that relate to the deal portfolio, that we reconcile c&a with SAP (via interface and manual journal entries)
BLUE colored tabs indicate data that was extracted from GTreasury PROD
**GL Transaction – data starting at column S is what I have manually entered and added formulas, respectively. Purpose is to get data in a format to allow comparison with Cognos data.
** GL Processing - data starting at column AA is what I have manually entered and added formulas, respectively. Purpose is to get data in a format to allow comparison with Cognos data.
Whoa, that's a lot. I had this window open to look at as I wound down in the evening, but that's a ton of info to get across.
You want to start by getting the relevant data in. Each sheet that you want to bring in will require it's own Input Data. I would start with getting those in and parse them to neat tables.
From there, I'm not sure what you want to compare. Take a look at the attached and see if that gets you started.
I've given some examples of replicating a couple of fields you had, but many look superfluous and so if I was to pick this up, the first thing I would do is get rid of those and see what's needed to be created.
Awesome thank you for the Start... and yes it is a lot I will reply with more Simple logic. My apologies for it being alot.