Browse Tool not tallying with Table Values

[klwee]

Dear Alteryx community,

So, I have been trying to troubleshoot why my data values disappeared from the Browse panel on the left for "Period" but if I look at the table at the bottom right, values up to 7 actually exist. 

I have 2 columns named Period just to check if any values were changed after appending.

I have already tried checking "Collect and display data profile information" as suggested in another thread, but it has already been checked earlier. 

Is this a known visual bug? 

Thank you. 

[mceleavey]

Hi @klwee ,

We would need to see your workflow and data. Can you post your workflow with some dummy data so we can check what's happening?

Thanks,

M.

[klwee]

Hi @mceleavey,

Here is my workflow.

[atcodedog05]

Hi @klwee 

In my browse I can see 2 more > option below the list.

Upon clicking it shows the full list.

I am using version 2021.1 and I can see you are using 2021.2 not sure if its a bug 🤔

@mceleavey can you check on your Alteryx what you are able to see? are you able to get this 2 more > option

Hope this helps : )

[klwee]

@atcodedog05 I'm currently using Version: 2021.3.1.47945. My colleague using 2021.2 helped with the dummy data replacement. 😅

[danilang · Accepted solution]

Hi @klwee 

As of 2020.3 Alteryx changed the the browse tool data profile from a complete profile to a "close-enough profile" for performance purposes (see Browse Tool Data Profiling section here).  It only uses a sub set of your data for profiling purposes  If you have values that only show up late in the dataset, these won't be displayed.  To get a true profile of your data use the Unique tool and the various tools from the Data Investigation palette

Dan