Getting a count by rows

[ievpal]

I have a huge dataset with lots of collumns and lots of rows.

What I`m trying to do is find count of empty values in every row.

I would know how to get this if that was columns, however, I am strugling with rows...

Data sample:

Required result:

[Joe_Mako · Accepted solution]

How about the attached?

The workflow performs a Transpose with id as the Key field, making the data very tall, then a Summarize to group by id and from under the String menu, Count Blank, and then a Join on id to bring the count back in.

[RodL]

@Joe_Mako,

You beat me to it...right when I was getting ready to post! And the funny thing is your diagram looks EXACTLY like mine!

[Treyson · Accepted solution]

Hello! I am not sure how many columns you are using but using your example, I believe I have found a quick fix using the Multi-Field Tool.

In the attached workflow I just selected all of the fields we wanted to check for blank values and then added an IF statement returning 1 and 0 in a new column for all of the columns selected. We later sum them.

I hope that helps.