Table Transformer - condition on any cell value

Kristian Bohm November 6, 2023

Hi,

I have a table with many columns.  I'd like to conditionally format ALL of these based on a cell value.

 

Crappy pseudo code...

 


Rather than:

SELECT
CASE
WHEN T1.'col1'="Yes" THEN blart

END AS 'col1'

CASE
WHEN T1.'col2'="Yes" THEN blart

END AS 'col2'

CASE
WHEN T1.'col3'="Yes" THEN blart

END AS 'col3'

...

CASE
WHEN T1.'col22'="Yes" THEN blart

END AS 'col22'

 



I'd rather do this:

SELECT
CASE
WHEN T1.* ="Yes" THEN blart

END AS *

 

1 answer

2 votes
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.
November 7, 2023

Hi @Kristian Bohm ,

Maybe the Table Spreadsheet macro will suit you better? It provides the Excel-like conditional formatting as well.

And if you already have a big native table with multiple columns created or your source table comes from the Page Properties Report macro, you may use the Spreadsheet from Table macro to turn your existing table in a spreadsheet and then apply the Excel-like conditional formatting.

Kristian Bohm November 7, 2023

Thank you.  I will try this out and let you know.

Like Stiltsoft support likes this
Kristian Bohm November 7, 2023

I'm not sure this will work for my case.  For my case (which I did not mention) I want to merge multiple tables using Transformer.

Else; I do think the Table Spreadsheet would work.

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.
November 7, 2023

Then you may merge your tables with the help of the Table Transformer macro (just merge and not color) and wrap this Table Transformer macro in the Spreadsheet from Table macro. Your merged table will be turned into a spreadsheet where you will be able to apply conditional formatting.

Like # people like this
Kristian Bohm November 7, 2023

I saw the 'Spreadsheet from Table' macro when investigating your suggestion but it's disabled on our system.

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events