LARGE DATA SET % of Records

[Cesc]

Hi Alteryx community,

Wanted to ask you help for a large dataset of +1 million. I have around 50 columns and need to understand whether all columns have the following:

The desired outcome is the following

NULL column % would be the percentage of fields that contain the word "NULL" in them

0s/blanks would be in case any field contains 0s or blank on a field

DATA would be everything else.

                               Data              NULL             0s/blanks

COLUMN1              75%              20%               5%

COLUMN2              50%              25%               25%

COLUMN3              ...

COLUMN4              ...

COLUMN5              ...

COLUMN6              

...COLUMN45

Best regards and thanks a lot in advance

[FrederikE · Accepted solution]

Hey @Cesc,

You can do something like this 

EDIT:

If you want to include % of a certain text, include such a formula (Tool 4):

[tristank]

Hope you are well @Cesc 

My preferred approach to this would be the field summary tool

This would allow you to get the percent of missing values and from there you could calculate the percent that is not missing. The caveat to this approach is that you wouldn't be able to get the percents of nulls and blanks. I believe in the tool they would combine. That said, using the data cleansing tool before the field summary tool to make any blanks or emptys null would be a good precaution.

Hope this helps!

Tristan

[Cesc · Accepted solution]

@FrederikEThanks a lot for your solution. Have to use transposition more and more.

I am very thankful for it, could complete my task in just an hour :)

Best regards,