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.
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.
Solved! Go to Solution.
kinda there could be other rules where if the value is greater > some value then place special character such as below.
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?
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.
so the short is it's doable. Assuming there is a lot of data - the individually rendered cells method could be worthwhile.
This look promising can you please share the workflow?
Thank you