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 CompanyProductSpecificationUnitsACB IncChips18nm-2AcmePhones5.6in3 Desired Output - split the units to +1 / -1 CompanyProductSpecificationUnitsACB IncChips18nm-1ACB IncChips18nm-1AcmePhones5.6in1AcmePhones5.6in1AcmePhones5.6in1 Thanks in advance!

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

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!

Tips and Tricks

Best Practices

Accepted answers

atcodedog05

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 : )

Units.yxmd

All comments

atcodedog05

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 : )

Units.yxmd

Wixard

This is perfect - thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703