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.

Remove Nulls

qgpl
8 - Asteroid
‎02-20-2023 06:08 AM

Hello! 

 

Please can someone help me get rid of the NULLS on all of formulated fields?

 

EXAMPLE.PNG

 

My expected output is:

 

Value1Company NameAccount Number 
437.47DAVIE6

 

I've tried a few formulas but can't seem to figure it out without removing other data from the other columns!

 

Thanks

Quennie

Labels:
Reply
1 REPLY 1
binuacs
21 - Polaris
‎02-20-2023 06:19 AM

@qgpl One way of doing this

binuacs_0-1676902762759.png

 

Remove_Null_200223.yxmd
Reply
0 Likes
Community Live
Labels
Top Solution Authors
View All