How to get the number of arrays results by row (Cell Splitter)


Is there any way I can get the number of arrays generated on each row by the Cell Splitter?

Here I can share you a picture with random data

NOTE: The first array is empty because I put the number six as the delimiter on the Cell Splitter

For example, the first and second row generated two arrays, the third, fourth and fifth generated three arrays. So I am trying to get something like this:

I don’t know if the “IF Switch” node would work? I’ve never used it before

Thanks in advance!

1 Like

Hi @NathanDrake,

I would suggest using an Unpivoting node with your array columns set as the value columns and the ID column set as the retained column. Then connect the output of the unpivoting node to a GroupBy node where you group on ID and count the ColumnValues field with the “Missing” check box deselected.

Kind regards,

1 Like

Columnaggregator Node with Count “Non missing”. For column selection you could use wildcard/regex to only include “Arr” Columns. (Man I wish there was a Pirate Smiley)


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.