Table Transformer changing zeros to blanks

Scott Gillespie_ibixpx

I have a Table Excerpt Include with various table values, including zeroes.  When I put this through Table Transformer, the zero value cells are blank.  My testing suggests this is due to my use of FORMATWIKI in Transformer.  I use that to set column widths, conditional text colors, etc.  When I remove the FORMATWIKI and just place the regular or calculated value, then zeros appear.

Is there any way to retain zeros for display in this situation?  I did find reference to using IFNULL to display zero instead of a blank, but IFNULL would need to be applied to every field impacted.  I wondered if there is another setting or "all inclusive" approach that would achieve the same result.

Katerina Rudkovskaya _Stiltsoft_

Hi @Scott Gillespie,

The original FORMATWIKI function shouldn’t change nulls to empty cells. I mean that if you have “0” in your column, then SQL queries

SELECT
FORMATWIKI("{cell:textColor=green|align=left|width=200px}", 'Column name', "{cell}")
AS 'Column name'
FROM T*

or

SELECT
FORMATWIKI("{cell:textColor=green|align=left|width=200px}" + 'Column name' + "{cell}")
AS 'Column name'
FROM T*

just change the color of this “0” and change the width of the column.



So, please refer to our support. Attach the page storage format of each page with the Table Excerpt macro inserted and of your master page with the Table Excerpt Include and Table Transformer macros. We’ll recreate them and see what data is pulled via the Table Excerpt Include macro and how you try to transform it.