We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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

Hello, 

how can i replace blank cell into specific word- 

 

Current output - 

 

F1F2
  
435345675756
567571232143

 

Expected Output

F1F2
DebitCredit 
435345675756
567571232143

 

Thank you 

 

Kauser 

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

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

 

Then repeat again for F2!

Labels
Top Solution Authors