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.
SOLVED

Find Not Null Cells Within a Column and Replace with X

NicoleAM
7 - Meteor

I'm very new and not good with the expressions so I can't figure out how to find any cells within a column that contain text (are not null) and replace that text with "X". I thought find and replace would be the way to go, but couldn't figure that out. Then I thought it would be just an expression in the formula tool, but I don't know how to edit the expressions to be anything other than they read. I was thinking: IF c THEN t ELSE f ENDIF?

 

In the same below I want to replace (San Jose) with an X and leave the other cells in that column blank.

 

 ZIP  Sales  SPH  Home ZIP
 60126  2000

 100

 
 60515  200  200  San Jose
 60559  500  20  San Jose
 85210  10000  700

 

Hopefully this IS as easy as I thought and someone can help me out! Thanks!

15 REPLIES 15
NicoleAM
7 - Meteor

Thanks a lot to both of you! I really appreciate your help and fast response!

FYI - I'm not sure what the deal was with trying to open the module because I was clicking on the download icon.

KaneG
Alteryx Alumni (Retired)

I can possibly answer the question related to downloading the file... Microsoft Edge perhaps?? Each .yxmd file is just an xml file at it's core. In the first few versions, Microsoft Edge does not allow you to save files that it recognises and it recognises this file as an xml, hence why it opens the file. 

 

If that is not the reason, then I'm not sure....

claroching
5 - Atom

Hi there, 

 

What's the best way to update this so:

1. if a cell in a specific column is "null" then populate with "New" 

2. if the cell is not "null" then keep the existing data as is

 

The below works  but then it replaces everything that is not null with "X"

IF (IsNull([Home ZIP])) THEN

   Null()

ELSE

   "X"

ENDIF

 

 

JohnJPS
15 - Aurora

Hi @claroching,

To leave it unaffected in the "else", just put in the field in question; for your example:

IF (IsNull([Home ZIP])) THEN
    "New"
ELSE
    [Home ZIP]
ENDIF

Hope that helps!

 - John

claroching
5 - Atom

Thanks a mill !!!

claroching
5 - Atom

Thanks a mill !!

Labels