This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!