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

Simple IF than statement question

kas
8 - Asteroid

I must be blind to something simple here, but can't see it...what's wrong with this statement? The error I get is "The field "" is not in the record. 

And if there is something better than Null() to create a blank result that'd be great too...

 

if [SSN] = "000000000" THEN Null() else [SSN] endif

 

Thanks!

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @kas

 

You're not giving a name to your new field in your Formula Tool.

If you want to keep it in your [SSN] column, you should select it right by the "+" button.

You must select or create a new field to use the Formula Tool.

 

Cheers,

kas
8 - Asteroid

Good grief...I knew I was just being blind...must still have holiday brain...


@Thableaus wrote:

Hi @kas

 

You're not giving a name to your new field in your Formula Tool.

If you want to keep it in your [SSN] column, you should select it right by the "+" button.

You must select or create a new field to use the Formula Tool.

 

Cheers,


 

Thanks so much!

Labels
Top Solution Authors