Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Why does "Browse Tool" "Profile" tab does not display empty/null rows?

pyalx
6 - Meteoroid

When I add a Browse Tool in an output of the workflow, it summarizes the data value count. Eg:

 

 

COL_1

abcd    1234

deab     42

wqas     15

 

 

That is via the browse tool Profile Tab.

 

But if look in the Table Tab, I do see that some of the rows are null.

 

My question is what does the Profile tab does not show the count of Null/NA or Empty field?

 

 

My Specs:

Alteryx Designer x64

Version: 2022.3.1.430

Running Non-Elevated

3 REPLIES 3
alexnajm
17 - Castor
17 - Castor

It should when you click on the individual fields. It will also give you a high level indication with the color bar at the top.

alexnajm_0-1681316717484.png

alexnajm_1-1681316741936.png

 

 

pyalx
6 - Meteoroid

@alexnajm

 

Thanks for sharing!   Is there a way to show the NA count or empty value count in the Profile tab? I want to have a count of NA values aswell, if any, without needing to click the individual fields?

alexnajm
17 - Castor
17 - Castor

The screenshot above has empty values as well! For NA, they would show in the counts for each individual column, not summarized. You could theoretically use a Summarize tool to group on the columns you want to valuate and the count of the values so you could see how many "NA" values there are

Labels
Top Solution Authors