Duplicate a row, splitting a large value from a column by 2?

jackersantos

I have a column with a large number (more than 14 digits) And everytime there is a number this large we would like to duplicate this row and subtract a fixed value from this column. Let's say the original number is 12345678942354, I want to subtract 9999999999999 from it, and create a new row where the original row would contain the result of this operation, and the second row would contain the rest. When we sum this 2 rows the result would be 12345678942354. Is it possible?

davidskaife

Hi @jackersantos 

Do you mean something like this?

Firstly add in a Record ID tool, then filter your numbers out where the length is greater than 14 (you'll need to convert to a string to do this), perform the calculations in a Formula tool, Transpose the data where the Record ID is a key column on both the true and false filter streams, then union back together, and finally sort on Record ID to put the data back into it's original order.

For the Formula tool i've created a field called 'Remainder' which is set as the fixed value, and in the original number field i subtract the 'remainder' from the value.

Value Split.yxmd