if else formula

Question

I have a formula to replace the unknowns with blank...

if [Payee addr 1] = 'UNKNOWN' then [Payee addr 1] = ' '
else [Payee addr 1]
endif

The output I'm getting is replacing the unknown with 0. I have tried changing the data type from VWstring to just string... any idea what might be causing it?

DawnDuong · Answer

i had encountered this when i used filters and pivot tables in the excel files then the next time i use Alteryx to write data to the same excel, the pivot and filters in Other tabs were removed.

i have not found a fix for this though.

Luke_C · Answer

@Idyllic_Data_Geek Can you share the configurations of your output tool?

Idyllic_Data_Geek · Answer

@DawnDuong and @Luke_C Thank you. Both the solutions work. Another question 🙂 when I open the output excel file then it is giving me an error. Attached is the screenshot. Any idea what might be causing it and how can I resolve it?

Alteryx Error.PNG