In a current workflow I have the issue that accounts payable numbers can have one to x bank accounts.
i.e. one accounts payable number with three bank accounts => KNIME creates 3 lines.
i.e. one accounts payable number with two bank accounts => KNIME creates 2 lines.
I would like to have the information of these three bank accounts in one line… How can I get to this point?
It would generally be best to at least give some sample data, or better yet a file, that could be copied/pasted, rather than a screenshot as this allows people to have a quick play as otherwise we have to try to imagine how it would work in our heads, which can lead to suggestions that don’t quite work.
I too was thinking unpivot, but then changed my mind to “pivot” but now having typed in some data, I found that even that became a little problematic.
I eventually settled on grouping (concatenating) by account number, and then unsplitting the cells.