Formula

[Kjaer]

Hi again

I have these three lines. In one "fomula" I have made a calculations for each column A, B and C. But if my data do not contain any data for f.ex column C (that means that there will only be a column A and B), I would like to make a condition, that if no column C, then just skip the calculation.

If the formula can be made in a better way, so I am open for any solution :-)

Number	A	B	C
5000	5	10	15
5001	10	20	30
5002	15	30	45

[sparksun · Accepted solution]

My solution with comments in the workflow, pls check.

[ArnaldoSandoval]

Hi @Kjaer 

Alteryx does not feature a function to check a column is present in the data  stream 😐 over the years this had been handled in different ways, we even have a macro to handle this scenario

• How to work with Fields that might not exist and avoiding Parse Errors this topic propose a solution similar to the one uploaded by @sparksun 
• CReW Macro Support includes the macro Ensure Fields which handle missing columns with elegance, this path requires you to install the CReW Macros in your workstation.
• Alteryx: Ensuring fields are in a data stream back in August 2013, Ned wrote this blog when releasing the macro, the blog include some explanation. He named the macro EnsureFieldsOnDataStream.yxmc

The macro is the most elegant way to handle missing columns, and I prefer its first version; actually the CReW version only add some validation to force the whole CReW is installed with all its macro, which may not be wise, as it force the installation of CReW everywhere or you modify their macro to removed their validation.

Hope this helps,

Arnaldo

PS: The attached package contains all the macros, it is up to you to pick the method you prefer.