My input is a table of 30 columns of bools.
I want to get 30 numbers counting how many trues there are in those 30 columns.
In Python with Numpy this is super easy, in SQL too.
However, with Alteryx I do not understand how to do so in an elegant way.
In the summarize tool there is a count Non Null but there is no count Non Zero (or Count True), how is this possible?
I am new to Alteryx and it's hard for me to get over such a missing essential feature.
Then I tried the solutions in this page:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Counting-True-and-False-in-a-column-of-Bool/td-p/33400?lightbox-message-images-33401=8904i519E3E61A01B6BEF
However, I'm not sure if that solves my problem.
A first solution, not very elegant IMO, is casting every 30 columns to Bytes through the Formula tool. However, it takes forever to do so because it is not possible to copy paste a formula inside the formula tool (another thing I cannot get my head around).
Another solution is to use the summarize tool via the group by then sum method, but I could not get it to work since in the screenshot of that page the bool column is already a byte but mine is a bool.
Then there is the other solution with the frequency table and I did not try it because at this point I do not want the frequencies I want only to count the number of True values.
As an example, here is a little test table of 2 columns and 5 rows:
col1 col2
True True
True False
False True
False False
True False
col1 has 3 True and col2 has 2 True, that what I want to get.
