Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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