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

emagnun
Contributor
October 21, 2024

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".
tt.jpg
tt.jpg

My expected result is as below. 
tt.jpg

 

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

2 answers

1 accepted

3 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 21, 2024

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"

emagnun
Contributor
October 22, 2024

That was exactly the issue. Thank you so much.

Like Stiltsoft support likes this
0 votes
Saeed Moradi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 21, 2024

Saeed

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events