We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

formula, !isnull

wonka1234
10 - Fireball
‎03-22-2022 01:18 PM

Hi,

 

How do I create a formula (same column) to get the !notnull values.

 

wonka1234_0-1647980307843.png

 

!IsNull(([Mainframe_ACF2]))  I am trying this but getting values of 0 and -1.

 

Thanks

 

Labels:
Reply
0 Likes
11 REPLIES 11
Qizhan
5 - Atom
‎11-23-2022 06:57 AM

@KrishnaChithrathil thank you so much

Reply
0 Likes
DenisZ
11 - Bolide
‎11-23-2022 10:12 PM

If you want to mark not null columns with for example 1, then use the formula tool and call it IF isNull([Field1]) THEN 1 else 0 ENDIF. 

 

Hope this helps

Reply
0 Likes
Community Live
Labels
Top Solution Authors
View All