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!
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.
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.