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
16 - Nebula
16 - Nebula

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
16 - Nebula
16 - Nebula

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