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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.