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

pyalx

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

Developer Tools

Tips and Tricks

Accepted answers

alexnajm

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.

All comments

alexnajm

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.

pyalx

@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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703