Issue with Excel output for special character

[TahoeLove]

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-...

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.

[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?

[TahoeLove]

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

[apathetichell]

O.k. - so I think I have a dyanmic solution - but it's not pretty - could you post what you posted as an image as a .yxdb or .xlsx file? basically I can see a granular dynamic table with the  magic of batch macro and render and then recreating that as a larger table.

also - can you confirm that non-zero values/a.k.a. red x can occur in any column?

[apathetichell]

 and here's  a slightly updated version

 

This would be my start - obviously the problems are - 1) we want individual cells not groups of them with the same vales. 2) how to join them. Developing solutions for 1) - 2) will require some summarize and some join tools.

[apathetichell]

 

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

[TahoeLove]

This look promising can you please share the workflow?

Thank you

[apathetichell · Accepted solution]

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.