Alteryx- calculating off the excel sheet

Question

Good evening,

I created an excel sheet with a long list of rules on it. I only need to enter a few dates and then the calculations will automatically run and get me the answer I need for it.

I would like to bring the excel document into alteryx, enter the dates into alteryx, and then have the excel formulas run appropriately. Is there a way to do so?

Each row has a slightly different rule so I am relying on excel to make my life a lot easier. Alternatively, I would have to create dozens of new formulas on alteryx and it just wouldn't work.

nikitapuniani · Answer

Hi,

I am trying to something similar

I have created a mapping file and it calculation for each line. I want alteryx to use the excel file, assign variables to all the inputs and use the math calculation to drive the results. Were you able to figure out how to do this?

thanks!

Qiu · Answer

@DanielGGreenbaum 
I think I might get what you need here.

We might want to consider the Dynamic Replace Tool.

Hypo Golf.yxzp

SeanAdams · Answer

Hey @DanielGGreenbaum

One way to do what you say is to write to a hidden sheet in Excel - and then refer to this so that all of your existing formulae work.

You can have the user enter the dates into Date Interface tools, and then write this back to the Excel.

Over time - you may find that moving your formuae out of Excel and into Alteryx makes them easier to maintain, but I get the point that you're looking for a solution to where you are right now.