nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Selective updation of table data doesn't work with table transformer script

emagnun

Hello,

As you can see in below table, there are zero values. I'm trying to use table tranformer to print "" for all 0 values , except for the row "Overall".

My expected result is as below.

But with the above code pasted, I'm getting my original source table as result. What's wrong? Pls help. @Stiltsoft support

Accepted answers

Stiltsoft support

Hi @emagnun ,

If you are still talking about our app that is Table Filter, Charts & Spreadsheets for Confluence and need help from our support and not from other Community members than it is better to refer to our support portal.

Please attach the page storage of your page (upper right corner of the page -> menu ... -> View storage format), we'll recreate your macro structure and the query and try to help.

As for now from your screenshot I can see that you use ' ' when you refer to strings.

'Func' = 'Overall'

The first one seems to be the column name, the second one seems to be a string: use " " with strings.

'Func' = "Overall"

All comments

Saeed Moradi_m9hy9b

Saeed

Stiltsoft support

Hi @emagnun ,

Please attach the page storage of your page (upper right corner of the page -> menu ... -> View storage format), we'll recreate your macro structure and the query and try to help.