I have sales data with columns Receipt, Item and Number of units bought. I would like the Number of units bought to be expanded from their original values to units of 1, i.e. such that if Receipt 1 has 2 units of Product A, then 2 rows will be created and the same method for all the other counts which are greater than 1 units. In the attached excel file is an example of what the data looks like and an example of what the outcome should be. Thank you
Solved! Go to Solution.
Hi @Roche
The Generate rows is perfect for what you want to do here.
There are a couple ways you can set it up, but I have gone with creating a new column to check it was building it successfully:
I loaded in the value needed (Initialization Expression) > checked that value is always greater than 0 (Conditional Expression) > when it's not subtract one and create a new row (Loop Expression)
I have attached the workflow as well. Let me know if you have any questions
Thank you for helping Sebastiaan and Joe!
@Roche Glad to help you out! Have a nice day!
Thank you Sebastiaan, enjoy your day!