SQL - update table with null values in row.

0 votes
How to show table with updated values for a column that i want to change before using the data source. I'm using mysql database for my data source.
Apr 2 in Tableau by sindhu
214 views

1 answer to this question.

0 votes

Hi Sindhu,

Before loading the data and fields from data source, write a custom sql statement to get those values from tables with nulls and then replace them.

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

UPDATE TABLE MESSAGES SET User_email_id = "old" where User_email_id IS 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
• 32,260 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
193 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
58 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
49 views
0 votes
1 answer

Is it possible to do a % of Table with an attribute in Tableau?

Hi Nithin, yes it is possible to ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 32,260 points
40 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,371 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
117 views
+2 votes
1 answer
0 votes
2 answers

SQL - table with rows with no null values.

SELECT primary_author, published_date, title FROM ...READ MORE

answered Sep 4 in Tableau by johnmario
• 160 points
164 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
• 32,260 points
951 views