In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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.
SOLVED

Replace blank with specific word

kauser
8 - Asteroid
‎09-23-2024 12:41 PM

Hello, 

how can i replace blank cell into specific word- 

 

Current output - 

 

F1F2
  
435345675756
567571232143

 

Expected Output

F1F2
DebitCredit 
435345675756
567571232143

 

Thank you 

 

Kauser 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
alexnajm
19 - Altair
19 - Altair
‎09-23-2024 12:43 PM

IF [F1]=Null() OR IsEmpty([F1]) THEN "Debit" ELSE [F1] ENDIF

 

Then repeat again for F2!

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All