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, 2019 in Tableau by sindhu
7,296 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, 2019 by Cherukuri
• 33,030 points
+1 vote
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, 2019 by johnmario
• 160 points

Related Questions In Tableau

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, 2019 in Tableau by Cherukuri
• 33,030 points
3,665 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, 2019 in Tableau by Cherukuri
• 33,030 points
5,600 views
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 25, 2018 in Tableau by Atul
• 10,240 points
7,204 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 27, 2018 in Tableau by ffdfd
• 5,550 points
367 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
718 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
2,687 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
9,392 views
+2 votes
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
1,277 views
+2 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP