Make Formula Tool dynamic | Replicate IFEXISTS of SQL in Formula tool

[RajatK]

Hi! 

I needed some help with a really silly problem which could be resolved by using IFEXISTS in SQL. I am not entirely sure on how I could get a workaround of the same in Alteryx. 

Let's say I have 2 input tools. 

1) January data - where I have 3 columns coming in, Category A, Category B and Category C. So I compute Category X as A+B+C.

2) February data - where I have just 2 columns, Category A and Category B. Since, I've replicated the same formula for computing Category X as A+B+C, Alteryx being smart enough detects C is missing and errors out. 

What could be the workaround for this, to make the formula tool dynamic? I have 10k lines of records coming in my actual data and the formula needs to necessarily be the same. Any inputs would be appreciated! Thanks! 

January: 

Feb: 

[atcodedog05 · Accepted solution]

Hi @RajatK 

Try this method which keeps the summing dyanmic.

Workflow:

Hope this helps : )

[RajatK]

Thank you so much, @atcodedog05 !

[atcodedog05]

Happy to help : ) @RajatK 

Cheers and have a nice day!