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

Not able to replace NULL Values

akshayhendre
7 - Meteor

Hello All,

 

What is difference between NULL from 1st image vs Null from 2nd Image?

Image 1Image 1Image 2Image 2

 

 

 

 

 

 

 

I am able to replace the null values in 1st image using multi row formula tool but getting no result for the NULL in 2nd Image.

 

Thank you 

5 REPLIES 5
ponraj
13 - Pulsar

null in first image is actual null()

null in second image is a text "NULL"

RobertOdera
13 - Pulsar

HI @akshayhendre 

 

Consider using the following argument in a Formula Tool, for image 2:

 

Let's say the column name is "Col2"

 

Then use:

IF [Col2] = 'NULL' THEN Null()

ELSE [Col2]

ENDIF

 

OR you can add a Multifield Formula Tool and configure it per snippet below

RNO2_0-1589119579578.png

 

RNO2_1-1589119681436.png

 

 

Please see the attachment.

Please mark as an acceptable Solution if this works for you.

Good Luck!

BenMoss
ACE Emeritus
ACE Emeritus

Hi @akshayhendre 

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!

akshayhendre
7 - Meteor

Thank you @ponraj for your reply and thank you @RobertOdera for your suggestions to tackle such issues.

 

Sure@BenMoss, I will make sure to take the action going forward.

RobertOdera
13 - Pulsar

You're most welcome @akshayhendre 

Thank you @BenMoss 

Labels