Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Help getting Started with this Alteryx Workflow

SashaAmerican
7 - Meteor

****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.

2 REPLIES 2
KGT
13 - Pulsar

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.

  • In the GL Transaction Input, I set it to no headers and then found the table myself.
  • There are several duplicate named columns and so they get renamed either on Input or at the Dynamic Rename.
  • One thing that gets people, is the Find/Replace with Append is the VLOOKUP replacement. A join tool is a proper join, not a vlookup. Work out what you want, as to whether it's a join or Vlookup.

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.

 

SashaAmerican
7 - Meteor

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.

 

 

Labels
Top Solution Authors