Table transformer loses source cell background color for nulls

[Green_ Desmond]

I am using a table transformer to simply sort data more easily. I found the table filter doesn't seem to work reliably when new data has been added or some data has been updated.

So, my transform query is very simple:

SELECT * FROM T*
ORDER BY 'Supported until'

The rows in the source table have background colours, which users update (I don't want to recreate the coloring logic in the query).

When the table transformer picks up the data, any columns which are empty have a white background after the transform. Any columns which have data are shown with the original background color from the source table, after the transform.

So, a row which had background color ends up with a mix of the original background color for columns which had data, along with white backgrounds on columns in that same row which do not have data! Not sure why it does that and it makes my colored rows look very odd when null values in columns are on a white background.

How do I ensure the table transform preserves the background colour of all rows and columns?

[Stiltsoft support]

Hi @Green_ Desmond ,

Unfortunately, the Table Transformer macro preserves background when there is any data in a cell as for now.

We do have such improvement on the roadmap and I've linked this question to our internal ticket: once the feature is released, we'll return here and you'll be notified.

Meanwhile, you can try using the Table Spreadsheet macro instead.