Browse tool not profiling correctly

Question

Hi Everyone - I have a .csv file with around 400K lines and i'm trying to analyze it using the browse tool. The browse tool reads the total records correctly (400K) but when i look at one field, it only profiles around 3000 records.

Does anyone know why this is happening and if there's a work around for this? Alteryx used to do it properly in previous versions i think.

echuong1 · Answer

Although not recommended, you can change the memory usage in the user settings under Options > User Settings > Defaults. This may allow you to profile your data.

You can also use a Select to narrow down your dataset prior to using a Browse.

AlterixNoob · Answer

Thanks - There's no particular tests i'm trying to perform which is the issue.  I want to understand the data which is over 400k lines and based on that understanding I will perform further analysis. It was quite handy to just apply the browse tool and filter the information easily and get an understanding of each field (i.e. how many nulls, what the information contains, any unique values? etc.)

I know you can do that with other tools which is great but it's way quicker to do it through a browse tool just to get an understanding of the data.

Jonathan-Sherman · Answer

What kind of tests are you trying to perform? Anything that can be found in the data profiling window you'll also be able to do with your standard summarise and unique tools i'd expect.