SQL - table with rows with no null values.

0 votes
How to show table with only rows with no null values for better visual? I'm using mysql database for my data source.
Apr 2 in Tableau by sindhu
113 views

2 answers to this question.

0 votes

Hi Sindhu,

Before loading the data and fields from the data source, write a custom SQL statement to get those values from tables without nulls.

If it is a single table then you can write this code to get the table contents without null values.

SELECT * FROM table WHERE field_name IS NOT NULL;

The new table can then be used to perform visualization.

For multiple tables, you should rewrite the code to fetch each table. You can then rename the query after creating and use the data.

The custom SQL table later joined with other tables just like actual tables.

hope this helps you

answered Apr 2 by Cherukuri
• 31,840 points
0 votes
SELECT
  primary_author,
  published_date,
  title
FROM
  books
WHERE
  (
    primary_author IS NOT NULL
  AND
    published_date IS NOT NULL
  );
Like this way you should execute your query for information or tech related support visit Data Recovery Dubai
answered Sep 4 by johnmario
• 140 points

Related Questions In Tableau

0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 24, 2018 in Tableau by Atul
• 10,240 points
1,311 views
0 votes
0 answers

What is the best method to create an extract with 20million rows?

I am facing issue while creating an ...READ MORE

Jul 26, 2018 in Tableau by Atul
• 5,530 points
37 views
0 votes
1 answer

Using Regex in Tableau, but only getting Null values.

Tableau regex engine is ICU, and there ...READ MORE

answered Aug 17, 2018 in Tableau by AwesomeSauce
• 860 points
54 views
0 votes
1 answer

How to ignore null values in your chart?

If you right click on the bar ...READ MORE

answered Aug 20, 2018 in Tableau by Nitish
• 630 points
42 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,206 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
98 views
+2 votes
1 answer
0 votes
1 answer

SQL - update table with null values in row.

Hi Sindhu, Before loading the data and fields from ...READ MORE

answered Apr 2 in Tableau by Cherukuri
• 31,840 points
141 views
0 votes
1 answer

Return rows with not null values in Tableau

Hi Nithin, You can add a calculated field ...READ MORE

answered Apr 10 in Tableau by Cherukuri
• 31,840 points
767 views