marketerone
marketerone 12 Dec 2020
2

Up next

Export Data from a KNIME workflow into a Tableau report
14 Jan 2021
Export Data from a KNIME workflow into a Tableau report
BisVue.com · 223 Views

How to replace Null literals in Tableau

Is this your company's video?
158 Views

In this silent video, you'll learn how to replace the word "Null" (Null literal) with a different string or blank space.

Read the full article here: Replacing Null Literals - https://kb.tableau.com/article....s/howto/replacing-nu

- - - - - - - - - - - - - -

Replace a null literal in the primary or only data source
1. Select Analysis and then Create Calculated Field
2. Name the field, enter the following calculation, and click OK:
IFNULL([Field Containing The Null Literal], 'string to replace the null literal')
For example,
IFNULL([Customer Name], '')
3. Use the new field you created in place of the original field.

Replace a null literal in a secondary data source (when data blending)
1. From the view, select the primary data source.
2. Select Analysis and then Create Calculated Field
3. Name the calculation, enter the following formula, then click OK:
IFNULL(ATTR([Data Source Name].[Field Name])), 'string to replace the null literal')
For example,
IFNULL(ATTR([Sample - Coffee Chain (Access)].[State]), '')
4. Use the new field you created in place of the original field.


Related solutions:
Replace NULL or missing data with zeros - https://kb.tableau.com/article....s/HowTo/populate-emp
Format Numbers and Null Values - https://onlinehelp.tableau.com..../current/pro/desktop

- - - - - - - - - - - - - -

Subscribe to the Tableau YouTube channel here: http://www.youtube.com/subscri....ption_center?add_use

Free Trial of Tableau: https://www.tableau.com/products/trial

Show more

About marketerone


0 Comments sort Sort By

Up next

Export Data from a KNIME workflow into a Tableau report
14 Jan 2021
Export Data from a KNIME workflow into a Tableau report
BisVue.com · 223 Views