Using Generate Rows Tool to split rows that have positive and negative numbers

[Wixard]

Hi all,

I am trying to split a row based on a number in that row (Units in the example below) - so know I should be using the Generate Row tool. I'm stuck because there are some negative numbers that I would like to split.

Would someone be able to help with the correct configuration? 😊

Original Table

Company	Product	Specification	Units
ACB Inc	Chips	18nm	-2
Acme	Phones	5.6in	3

Desired Output - split the units to +1 / -1

Company	Product	Specification	Units
ACB Inc	Chips	18nm	-1
ACB Inc	Chips	18nm	-1
Acme	Phones	5.6in	1
Acme	Phones	5.6in	1
Acme	Phones	5.6in	1

Thanks in advance!

[atcodedog05 · Accepted solution]

Hi @Wixard 

Here is how you can do it.

Workflow:

1. Using generate row tool to generate rows equal to units number.

2. Using formula tool to set unit to 1 or -1 based on the original unit.

Hope this helps : )

[Wixard]

This is perfect - thank you!

[atcodedog05]

Happy to help : ) @Wixard 

Cheers and have a nice day!