Issue with Excel output for special character

I have a business case where I need to insert a special character such as a Check or X for the for a given value if the conditions are met.

this is obviously not the correct syntax for the expression but this is the concept I am trying solve.

If Submission date ="1" then "Special Character "X" + Submission Date" else Submission date endif

For reference I found this article on the message board which works great for replacing.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Issue-with-PNG-PDF-output-for-special-character/td-p/141935

This is a example of how I would like it to look in the end.

The attached workflow has some dummy data to help kick off the process.

Thank you in advanced.

Example.yxmd

Reporting

Output

Accepted answers

apathetichell

Sure - but keep in mind that it still will need some work to get your data as you want. As I see it - you'll have to add an outer batch macro column and then the summarize/union and summarize horizontal for the final columns will do their work.

rendering by cell.yxzp

All comments

apathetichell

Formula building doesn't really work in Table - but your dual column rows can create a red X and then a 1 in Arial/black/size 8.

Is that what you wanted?

Example table colors.yxmd

TahoeLove

kinda there could be other rules where if the value is greater > some value then place special character such as below.

apathetichell

2021-05-13 (7).png

so the short is it's doable. Assuming there is a lot of data - the individually rendered cells method could be worthwhile.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703