Hi everyone,
I would like to break down some sets of data based on their corresponding values.
Here is the data. The amount of accessories correlates to the amount of unit.
However, I want to break down each accessory based on the unique chassis number. So that for each chassis no. of a unit type, the values of unit amount and accessories amount are always 1. Below is the expected outcome of what I’m trying to do.
Is there any way to automate this in Knime?
Best regards,
Jean
Could you please provide actual data rather than a screenshot? You’re more likely to get assistance if potential helpers don’t have to recreate your data.
Of course. Thanks for your input. Here’s the data sample:
Sample.xlsx (11.8 KB)
Hi,
not exactly the same result but almost:
I hope you do not need the missing values:
Hi, thanks for your response.
Could you please elaborate on the specifics of the nodes? I’m afraid I can’t replicate the workflow you created.
Hi,
you can download the workflow from my hub instance. Just click on the link:
Link to Hub
