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
12 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi Sindhu,

Before loading the data and fields from 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
• 13,860 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,200 points
353 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,470 points
24 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
• 830 points
25 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
28 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,200 points
919 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,200 points
36 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
• 13,860 points
14 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
• 13,860 points
42 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.