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.

If null statement

Cherkos12
7 - Meteor
‎12-09-2021 01:50 PM

This is the type of output i was hoping to get but my formula doesn't seem to produce this. How'd i got about capturing this?

 

CompanyField 1Field 2Output
AAGAGAG
BAE AE
C BCBC
DZY ZY
Labels:
Reply
0 Likes
4 REPLIES 4
mathieuf
Alteryx
Alteryx
‎12-10-2021 02:50 AM

Hi @Cherkos12,

 

Try this

 

mathieuf_0-1639133344073.png

 

null.yxmd
Reply
0 Likes
Cherkos12
7 - Meteor
‎12-10-2021 08:35 AM

Thanks. i tried it and didn't work for me.

Reply
0 Likes
mathieuf
Alteryx
Alteryx
‎12-13-2021 12:44 AM

I have the following output

 

mathieuf_0-1639385024467.png

 

How can I help?

Reply
0 Likes
binuacs
21 - Polaris
‎12-13-2021 05:17 AM

 

@Cherkos12 

 

IIF(IsEmpty(Trim([Field 2])),[Field 1],IIF(IsEmpty(Trim([Field 1])),[Field 2],[Field 1]))

 

Spoiler
binuacs_0-1639401407879.png

 

Reply
0 Likes
Live Office Hours
Labels
Top Solution Authors
View All