Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We are performing scheduled maintenance on our single sign on app. You man notice intermittent login issues. Thank you for your patience!
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.
SOLVED

Vlookup #N/A in Excel - how will you put a text in Alteryx?

Virgie0113
7 - Meteor
‎11-09-2021 01:23 PM

Virgie0113_0-1636492656959.png

In excel, when you use a vlookup and if there is no match it will show #NA.  I am trying to do this in Alteryx. I use" join" function to do a vlookup then I used "union" so everything will still show in 1 file.  Is there a way for me to put a text  on the rows that are blank just like #NA in excel (instead of just living the cell blank)?

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor
‎11-09-2021 01:30 PM

Hi @Virgie0113 

 

One approach would be to use a formula tool for the field in question. The function would be:

 

IF IsEmpty([Field Name])

Then "Text"

Else [Field Name]

endif

Reply
Virgie0113
7 - Meteor
‎11-09-2021 01:50 PM

Hi, this works.  Thank you so much!

Reply
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All