I am using table transformer to display results from a JIRA query. I was wondering if there is a way to replace the empty fields with text that actually says "Empty"?
I had tried something like this without success
Is there a way to replace the blank values with a different value?
Hi @Jason Dyke ,
You may try the following SQL query:
SELECT
CASE WHEN 'Col A' IS NULL
THEN "Empty"
ELSE 'Col A'
END
AS 'Col A'
FROM T*
Here 'Col A' is the name of your column where you want to replace empty cells with the word "Empty".
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.