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, 2019 in Tableau by sindhu
1,092 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, 2019 by Cherukuri
• 32,460 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
620 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
122 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
288 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, 2019 in Tableau by Cherukuri
• 32,460 points
106 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
3,939 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
243 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, 2019 in Tableau by johnmario
• 160 points
1,193 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
• 32,460 points
2,313 views