Excel Alteryx, IF Condition

[MahanteshS]

Hi All,

I have an excel file, I am using formula tool to perform one IF ELSE Condition, Requirement is if Condition is pass THEN i have to write as -  "Chek mark Symbol" (character p in Bookshelf Symbol 7) , ELSE  - "X"

Please tell me how can i send "Chek mark Symbol" through  alteryx, i am writing this output in a excel column, or let me know, is there any alternative solution for this .

Thanks,

Mahantesh

[MahanteshS]

Hi,

Thanks for your response, May I know, how you are passing or typing this symbol ?

Thanks,
Mahantesh

[PaulN · Accepted solution]

Hi @MahanteshS,

Thank you for posting!

I know that this is not exactly the answer to your question but maybe following could help ?

You can actually use symbol ✓ in your formula. It could be copied from an existing source -like current page for instance- or from Character map (code: 221A)

Example:

if [Result] == "pass" then "✓" else "" endif

Kind regards,

Paul Noirel

Sr Customer Engineer, Alteryx

[MahanteshS]

Thank you for your solution, its working for me !