Duplicate rows based on a given value of the cell
Hi Knime Community, I’m not sure how to execute this, the task is to add/duplicate the row based on the number of claim quantity, if the claim quantity is 7 then the row for that specific data should be also 7 (it creates each row based on the # of claim qty). I did try the unpivot but since the reference is in the cell value itself it does not reflect. I’m also thinking of adding a counter generation but I’m not sure where to go from there.
Here is the initial format:
This should be the final format (sample/reference Row0):