Replacement of blank cells in table

Question

I am creating a table transformer query to merge multiple cells and replace blank cells with 0, i know how to do it for one row,but i want to do it for the whole table, is there a solution

Stiltsoft support · Answer

Let's move to our support then as I have mentioned before. There you may share your screenshots and your current SQL query.

In general your query may look smth like this:

SELECT 
CASE WHEN 'Column A' IS NULL
THEN "0"
ELSE 'Column A'
END
AS 'Column A',
CASE WHEN 'Column B' IS NULL
THEN "0"
ELSE 'Column B'
END
AS 'Column B'
FROM T*

So, if your query works fine for one column, you just repeat the CASE WHEN statement for other columns.

Try to use the hints given by the Table Transformer macro: use not the plain column names such as 'Column A' but full names T1.'Column A'. Type in the T1. part and wait for the autocomplete to give you a list of available columns. Maybe the issue is that you use different column names in your query.

In may happen when you work with a pivot table with a complex merged header: the Table Transformer macro splits merged cells and your column names may be concatenated.

meherengeez · Answer

I will not be able to share the screenshot,...but i have a pivot created using jql query..that pivot has many columns as blank, i am trying to fill the blank fields with 0 using table transformer...the query i have works fine on one column, but does not work when i try to do for many columns in the same table

Stiltsoft support · Answer

Hi @meherengeez ,

Not sure what you are trying to do - you may share your screenshots and current query here or via our support portal that is confidential.

And as SQL queries work with column names and your query works for a one-row table, it should work fine for other rows as well.