LARGE DATA SET % of Records

Question

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 Answer

Hey @Cesc,

You can do something like this

EDIT:

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

Cesc · Accepted Answer

@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,