Alteryx Designer Desktop Discussions

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

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

RajatK
8 - Asteroid

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: 

RajatK_0-1646046324678.png



Feb: 

RajatK_1-1646046349278.png



3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @RajatK 

 

Try this method which keeps the summing dyanmic.

 

Workflow:

atcodedog05_0-1646046708673.png

 

Hope this helps : )

 

RajatK
8 - Asteroid

Thank you so much, @atcodedog05 !

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @RajatK 

Cheers and have a nice day!

Labels