Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Replacement of blank cells in table

meherengeez
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!
December 19, 2023

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 

1 answer

3 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.
December 19, 2023

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.

meherengeez
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!
December 19, 2023

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
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.
December 20, 2023

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events