Тёмный
No video :(

Tableau - How to replace null with blank or zero using ISNULL function || ISNULL function explained 

Tableau Tip
Подписаться 7 тыс.
Просмотров 31 тыс.
50% 1

ISNULL function in Tableau:
ISNULL is a boolean function. Meaning it
returns TRUE or FALSE
SYNTAX: ISNULL(exp1)
It returns true if the exp1 is null
else returns false
Using this function lets replace null
with blanks or string
eg1: exp1 of datatype string
Replace null with NA:
---------------------
if ISNULL([Sub-cateogry])=TRUE then 'NA'
ELSE [Sub-cateogry] END
Replace null with blank:
-----------------------
if ISNULL([Sub-cateogry])=TRUE then ''
ELSE [Sub-cateogry] END
//here keeping =true is optional
eg2: exp1 of datatype int
Lets replace blank in Profit with 0
if ISNULL([Profit]) then 0
ELSE [Profit] END

Опубликовано:

 

29 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@BhujithKumar
@BhujithKumar 4 года назад
All your videos are very helpful.I am watching all.Continue the good work.Keep posting more content.
@TableauTip
@TableauTip 4 года назад
Keep watching
@bharathkumar017
@bharathkumar017 Год назад
It works thanx..!
@TableauTip
@TableauTip Год назад
You're welcome!
@jenkinsmacedo9095
@jenkinsmacedo9095 3 года назад
Replacing Null value for text is easiest compare to dates. The easiest to get Null for text data is highlighting the Null value and right click and select "Alias". Replace the Null value for text data in the alias with a space and ok. It removes all Null for that text data.
@superstarstory3282
@superstarstory3282 4 года назад
Thanks for upload, I'm ur follower for ur good content videos, keep adding more
@TableauTip
@TableauTip 4 года назад
Keep watching
@krishnavenigunturu8825
@krishnavenigunturu8825 3 года назад
Thank you for the video. can you please do for dates also for replacing null values
@avasartistrystudio3230
@avasartistrystudio3230 3 года назад
Replacing Null value for text is easiest compare to dates. The easiest to get Null for text data is highlighting the Null value and right click and select "Alias". Replace the Null value for text data in the alias with a space and ok. It removes all Null for that text data.
Далее
How to Deal with Nulls in Tableau (IFNULL, ISNULL, ZN)
11:51
Top N & Bottom N vs Others in Tableau
13:39
Просмотров 4,1 тыс.
The Index ( ) function in Tableau
14:12
Просмотров 23 тыс.