Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Requesting help in conditional columns

Manjari
8 - Asteroid

Hi All, 

 

I have a data set like below, I use a formula tool to find col4 = (col1+col2)-col3 

But some times not all the columns are present in data set. for eg. I have just col1 and col2 then the col4 formula throws an error. 

Is there a way in Alteryx to mention only if column (col3) is present use this formula (col1+col2)-col3  else just use col1+col2

 

Col1Col2Col3 
1.26.74.6
4.55.47.8
3 REPLIES 3
Luke_C
17 - Castor

Hi @Manjari 

 

When you say not present, is the field missing entirely or are the values null for the field?

Manjari
8 - Asteroid

@Luke_C : Thank you for responding. 

The field is missing entirely 

Luke_C
17 - Castor

Hi @Manjari 

 

I would have an text input with just the headers to union onto the data, that way if col3 is missing it gets created with all null values. That way you can keep the formula consistent.

 

Luke_C_0-1648127192944.png

 

 

Labels