Unique binning challenge

[nan]

Oh wow, this was a bit of a challenge (and I got confused by the instruction, too).
Here’s my attempt: 85922 Binning Challenge – KNIME Community Hub

[badger101]

Thanks @nan for providing an alternative. Applying yours to Output B produces one mistaken output row, but it worked well for Output A

Several new nodes I find quite interesting there that you used. Will definitely remember to use them in my future tasks, especially the new Cell Extractor Node!

[ActionAndi]

Hi @badger101 ,

I’m wondering why you need to take groups into your final result even though they don’t have any quantities.
Can you write something about the context you are working on? I’m just curious
Andreas

[badger101]

@ActionAndi The “group” here represents the unique RowIDs from an upstream dataset.

[badger101]

To those like me who was looking for an alternative workaround to work with cells containing large digits, this is what I use for my current project:

• It is tested on various datasets already. Works great.
• I have also incorporated a quality check at the end such that checking for the validity of the output table can be done in one place without having to eyeball at different locations in the workflow.

Here’s the workflow:
Unique binning challenge by badger101.knwf (373.8 KB)