Basically, I need to manipulate the below data set to add rows for each number in the defined range (indicated by the period).
column 1 column 2 column 3
1000 67401.67499 500000.699999
So as an example the output should be something like:
1001-67401-500000
1001-67401-500001
1001-67401-500002
*repeating until 1001-67401-699999*
Then we start with the second number in column 2:
1001-67402-500000
1001-67402-500001
*and so on*
So I have a way to accomplish this already using a Regex expression that looks at a specific field and creates 2 new fields at the end for the start and end of the range and then added in another column that keeps a running track of what number should replace that column on each line item. The problem is when I apply this logic to my large dataset it blows up the data far too much. I have a list of all true combinations of the three fields so I am wondering how I can manipulate the add rows tool or otherwise to only add a row if it shows up in this other file (ex. lets say if you were to look in my other file you would see 1001-67401-500000 and 1001-67401-500001 are real combinations but not anything between 1001-67401-500001 and 1001-67401-699995).
