If Statement linked to separate data source

[gcastle]

Hi, 

I'm currently trying to do some basic calculations in an Alteryx DB using a Nested If linked to a separate spreadsheet.

1. Is there a way to do this where the rules are dynamic, being read off a excel input (there are many calculations that need to be done, so would like to automate this rather than requiring manual intervention)?

In the excel attached, column C in the 'Input_Output' tab is calculated using an IF function linked to the 'Group' tab.

2. As I mentioned, there are a number of these calculations to be completed. Is there a way to stop this calculation/process from happening, e.g. if there is a 'NO' in a specific cell so this process doesn't continue.

Thanks, 

George

[patrick_digan · Accepted solution]

@gcastle See if the attached v 11.0 workflow is close to what you're looking for. I think the dynamic replace will be your friend here. As for your second bullet, I'm not your exact requirement. If the NO is in your data, could you use a filter? Another option would be the message tool which may have some of the features that you're looking for as it relates to halting processing.

[gcastle]

Thanks Patrick, this works great :)