can we get the special charter show in the calculated column

[Raj_007]

Hi All,

I have this scenario where the query hits the SQL Server database. In Alteryx 2019.4 iam trying to create a calculated column to get the symbol X for wrong and the correct symbol ✅ 

i have these symbols in Qlikview with the  an IF condition If(KRI1 = 1, chr(10004),If(KRI1 = 2, '', chr(10008))
is this possible in Alteryx or should I look for options in SQL Server

[fmvizcaino]

Hi @Raj_007 ,

It is not possible to show special characters in the results tab of a browse tool.

But if you are looking for reporting with Alteryx, here it is.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Using-Images-in-Reporting-Tables/ta...

Best,

Fernando Vizcaino

[danilang · Accepted solution]

Hi @Raj_007 

You can insert special characters into your non-reporting output as well using CharFromInt()

Dan

[Raj_007]

Hi Danilan, thank you so much for the solution- this is what i have been looking for

[fmvizcaino]

I had no idea this was possible @danilang .

Sorry @Raj_007 , living and learning..