Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

if there are nulls in my columns, I need to add a new column 'Note' which says no data.

poornimak
7 - Meteor

Hi

 Can someone help creating a new columns if my data say

[Field4], [Field5],[[Field6] are [Nulls], then I need to create a new column with a remark/note to mention that data is not available.

2 REPLIES 2
binu_acs
21 - Polaris

@poornimak If all three columns should be null to display the message then you can write the below formula in the formula tool

IIF (IsNull([Field4]) AND IsNull( [Field5]) AND ISNull([Field6]),'Data is not available',Null())

If any one of the fields is Null then use the OR instead of AND in the above formula 

ShankerV
17 - Castor

Hi @poornimak 

 

Please use the formula tool, 

 

In the Configuration Pane, Select Add Column and Type your name of the new desired column.

 

Then use the below formula, 

IF IsEmpty([Field4]) AND IsEmpty([Field5]) AND ISEmpty([Field6])
THEN "Data is not available"
ELSE Null()
ENDIF

 

Many thanks

Shanker V

Labels
Top Solution Authors