General Discussions

Discuss any topics that are not product-specific here.
SOLVED

(if) statement when the rows in a column are empty

SubbuSharma
7 - Meteor

Hi There, 

 

I have written a (if) statement to bring in a specific value when the rows are blank. However, I am not able to get the end result. Please see the formula & the highlighted section below.

Let me know how to go about this.

 

if [Review/action needed by]="Breanna" then "Client Care Investigators"
elseif [Review/action needed by]="Farah" then "Client Care Investigators"
elseif [Review/action needed by]="Muhammad" then "Client Care Investigators"
elseif [Review/action needed by]="Shaliny" then "Client Care Investigators"
elseif [Review/action needed by]="Breana" then "Client Care Investigators"
elseif [Review/action needed by]="Tammy" then "Client Care Investigators"
elseif [Review/action needed by]="N/A" then "Client Care Investigators"
elseif [Review/action needed by]="([IsNull])" then "Client Care Investigators"
elseif [Review/action needed by]="Kerry Ann" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Marilia" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Firdaus" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Trina" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Patrick" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Anu" then "Compliance Officers Reviewing"
else "New"
ENDIF

3 REPLIES 3
IraWatt
16 - Nebula

Hey @SubbuSharma,

I would write the section you have highlighted as:

 

elseif [Review/action needed by]=Null() then "Client Care Investigators"

 

Or if you also want to also include blank cells:

 

elseif isEmpty([Review/action needed by]) then "Client Care Investigators"

Both these functions are found in the test section of the functions list:

IraWatt_0-1659104803893.png

More information on the found here Functions: Quick Reference | Alteryx Help

 

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

SubbuSharma
7 - Meteor

Thank you @IraWatt , that was really helpful.

have a good one.

IraWatt
16 - Nebula

Great to hear @SubbuSharma, Happy Friday ! 😄

Labels