Help with merging columns and counts

[leonaa01]

I have a survey with multiple options so I separated them into separate columns for counting

I need to merge them into one column with count numbers?

Please help

[HansS]

Hi @leonaa01

To count the number of columns with an answer you can use the Column Aggregator node. Don’t forget to un-check Missing.

gr. Hans

[leonaa01]

Hi Hans

Thanks for the reply

I need the total counts e.g. how many selected people selected each option?

They could select multiple options

Is there a way to do that with column aggregator?

Thanks

[leonaa01]

This is what it looked like before I separated the columns

[HansS]

Hi @leonaa01

Then I misunderstood your question. One way to count the responses is to UnPivot the table with the …UnPivot node. In the configuration the Value Columns are the columns with the answers to count. And it is a good idea to remove those columns (exclude) from the Retained Columns. After execution the node, your result is in the ColumnValues column.

gr. Hans

[leonaa01]

Thank you Hans that worked