Alteryx Designer Desktop Discussions

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

Easiest way to recreate this Excel table?

BSmithdubz
8 - Asteroid

I'm attempting to incorporate this data into a larger workflow. The first table is just input values while the second two tables are formulas. Fairly new to Alteryx, and I'm thinking I could do this with some formula tools and a could others, but was hoping someone could give me advice on how to do this with as few tools as possible. 

BSmithPdubz_0-1598361782264.png

The change in 2019 formula is different than the rest of the formulas in the 2nd table, and the December 2018 Actual in the third table is an input from the rest of the WF, while the rest of the data in that table can be performed with one formula. 

 

Thanks for the help!

 

11 REPLIES 11
BSmithdubz
8 - Asteroid

My alteryx has that tool, strange it didn't load. 

 

Either way, I played around with this for the last couple hours and I think I got it working as a batch macro with the external actual rate data. I'll include a package in case you'd like to take a look. Thanks for everything, this would have taken forever without your help. 

ImadZidan
12 - Quasar

Hello @BSmithdubz ,

 

I had a look and impressive.

 

Well done mate, Team work.

Labels