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!

General Discussions

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

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

SubbuSharma
8 - Asteroid

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
17 - Castor
17 - Castor

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
8 - Asteroid

Thank you @IraWatt , that was really helpful.

have a good one.

IraWatt
17 - Castor
17 - Castor

Great to hear @SubbuSharma, Happy Friday ! 😄

Labels