Hello again :)
I am working with groups and loops. There is a restriction that a group of data can only be handled by a workflow if all rows withing group have the same value in one column. If they differe they sholud be filtered out or splitted to antoher node.
Col1 | Groupkey | Important_Col |
<Testdata> | 1 | N |
<Testdata> | 1 | N |
<Testdata> | 1 | N |
<Testdata> | 1 | Y |
<Testdata> | 1 | N |
In the example shown above the Important_Col has more then 1 Value (There is an Y and N) and it should be filtered out.
I am not able to use the shifted note because do not know how many rows each group has.
Maybe use the Java node? I have totally no inspiration how to solve this.
Has anyone a good idea or how to start?
Thank you very much for your time.