creating series of data with required values

[PB41091]

I have a data like this

A	B	C	value
1	0.10%	>1.0 Year | <= 1.5 Year	250
1	0.50%	>1.0 Year | <= 1.5 Year	290

I want to create a series of output where the 'value' field is populated with 50 values incremental and 10 values decremental of the value populated in column in the difference of 5

I have several combination for 'A' and 'B'. I want to create output value considering 'A' and 'B'

Output should look like this

A	B	C	value
1	0.10%	>1.0 Year | <= 1.5 Year	250
1	0.10%	>1.0 Year | <= 1.5 Year	205
1	0.10%	>1.0 Year | <= 1.5 Year	210
1	0.10%	>1.0 Year | <= 1.5 Year	215
1	0.10%	>1.0 Year | <= 1.5 Year	220
1	0.10%	>1.0 Year | <= 1.5 Year	225
1	0.10%	>1.0 Year | <= 1.5 Year	230
1	0.10%	>1.0 Year | <= 1.5 Year	235
1	0.10%	>1.0 Year | <= 1.5 Year	240
1	0.10%	>1.0 Year | <= 1.5 Year	245
1	0.10%	>1.0 Year | <= 1.5 Year	250
1	0.10%	>1.0 Year | <= 1.5 Year	255
1	0.10%	>1.0 Year | <= 1.5 Year	260
1	0.10%	>1.0 Year | <= 1.5 Year	265
1	0.10%	>1.0 Year | <= 1.5 Year	270
1	0.10%	>1.0 Year | <= 1.5 Year	275
1	0.10%	>1.0 Year | <= 1.5 Year	280
1	0.10%	>1.0 Year | <= 1.5 Year	285
1	0.10%	>1.0 Year | <= 1.5 Year	290
1	0.10%	>1.0 Year | <= 1.5 Year	295
1	0.10%	>1.0 Year | <= 1.5 Year	300
1	0.10%	>1.0 Year | <= 1.5 Year	305
1	0.10%	>1.0 Year | <= 1.5 Year	310
1	0.10%	>1.0 Year | <= 1.5 Year	315
1	0.10%	>1.0 Year | <= 1.5 Year	320
1	0.10%	>1.0 Year | <= 1.5 Year	325
1	0.10%	>1.0 Year | <= 1.5 Year	330
1	0.10%	>1.0 Year | <= 1.5 Year	335
1	0.10%	>1.0 Year | <= 1.5 Year	340
1	0.10%	>1.0 Year | <= 1.5 Year	345
1	0.10%	>1.0 Year | <= 1.5 Year	350
1	0.10%	>1.0 Year | <= 1.5 Year	355
1	0.10%	>1.0 Year | <= 1.5 Year	360
1	0.10%	>1.0 Year | <= 1.5 Year	365
1	0.10%	>1.0 Year | <= 1.5 Year	370
1	0.10%	>1.0 Year | <= 1.5 Year	375
1	0.10%	>1.0 Year | <= 1.5 Year	380
1	0.10%	>1.0 Year | <= 1.5 Year	385
1	0.10%	>1.0 Year | <= 1.5 Year	390
1	0.10%	>1.0 Year | <= 1.5 Year	395
1	0.10%	>1.0 Year | <= 1.5 Year	400
1	0.10%	>1.0 Year | <= 1.5 Year	405
1	0.10%	>1.0 Year | <= 1.5 Year	410
1	0.10%	>1.0 Year | <= 1.5 Year	415
1	0.10%	>1.0 Year | <= 1.5 Year	420
1	0.10%	>1.0 Year | <= 1.5 Year	425
1	0.10%	>1.0 Year | <= 1.5 Year	430
1	0.10%	>1.0 Year | <= 1.5 Year	435
1	0.10%	>1.0 Year | <= 1.5 Year	440
1	0.10%	>1.0 Year | <= 1.5 Year	445
1	0.10%	>1.0 Year | <= 1.5 Year	450
1	0.10%	>1.0 Year | <= 1.5 Year	455
1	0.10%	>1.0 Year | <= 1.5 Year	460
1	0.10%	>1.0 Year | <= 1.5 Year	465
1	0.10%	>1.0 Year | <= 1.5 Year	470
1	0.10%	>1.0 Year | <= 1.5 Year	475
1	0.10%	>1.0 Year | <= 1.5 Year	480
1	0.10%	>1.0 Year | <= 1.5 Year	485
1	0.10%	>1.0 Year | <= 1.5 Year	490
1	0.10%	>1.0 Year | <= 1.5 Year	495
1	0.50%	>1.0 Year | <= 1.5 Year	235
1	0.50%	>1.0 Year | <= 1.5 Year	240
1	0.50%	>1.0 Year | <= 1.5 Year	245
1	0.50%	>1.0 Year | <= 1.5 Year	250
1	0.50%	>1.0 Year | <= 1.5 Year	255
1	0.50%	>1.0 Year | <= 1.5 Year	260
1	0.50%	>1.0 Year | <= 1.5 Year	265
1	0.50%	>1.0 Year | <= 1.5 Year	270
1	0.50%	>1.0 Year | <= 1.5 Year	275
1	0.50%	>1.0 Year | <= 1.5 Year	280
1	0.50%	>1.0 Year | <= 1.5 Year	285
1	0.50%	>1.0 Year | <= 1.5 Year	290
1	0.50%	>1.0 Year | <= 1.5 Year	295
1	0.50%	>1.0 Year | <= 1.5 Year	300
1	0.50%	>1.0 Year | <= 1.5 Year	305
1	0.50%	>1.0 Year | <= 1.5 Year	310
1	0.50%	>1.0 Year | <= 1.5 Year	315
1	0.50%	>1.0 Year | <= 1.5 Year	320
1	0.50%	>1.0 Year | <= 1.5 Year	325
1	0.50%	>1.0 Year | <= 1.5 Year	330
1	0.50%	>1.0 Year | <= 1.5 Year	335
1	0.50%	>1.0 Year | <= 1.5 Year	340
1	0.50%	>1.0 Year | <= 1.5 Year	345
1	0.50%	>1.0 Year | <= 1.5 Year	350
1	0.50%	>1.0 Year | <= 1.5 Year	355
1	0.50%	>1.0 Year | <= 1.5 Year	360
1	0.50%	>1.0 Year | <= 1.5 Year	365
1	0.50%	>1.0 Year | <= 1.5 Year	370
1	0.50%	>1.0 Year | <= 1.5 Year	375
1	0.50%	>1.0 Year | <= 1.5 Year	380
1	0.50%	>1.0 Year | <= 1.5 Year	385
1	0.50%	>1.0 Year | <= 1.5 Year	390
1	0.50%	>1.0 Year | <= 1.5 Year	395
1	0.50%	>1.0 Year | <= 1.5 Year	400
1	0.50%	>1.0 Year | <= 1.5 Year	405
1	0.50%	>1.0 Year | <= 1.5 Year	410
1	0.50%	>1.0 Year | <= 1.5 Year	415
1	0.50%	>1.0 Year | <= 1.5 Year	420
1	0.50%	>1.0 Year | <= 1.5 Year	425
1	0.50%	>1.0 Year | <= 1.5 Year	430
1	0.50%	>1.0 Year | <= 1.5 Year	435
1	0.50%	>1.0 Year | <= 1.5 Year	440
1	0.50%	>1.0 Year | <= 1.5 Year	445
1	0.50%	>1.0 Year | <= 1.5 Year	450
1	0.50%	>1.0 Year | <= 1.5 Year	455
1	0.50%	>1.0 Year | <= 1.5 Year	460
1	0.50%	>1.0 Year | <= 1.5 Year	465
1	0.50%	>1.0 Year | <= 1.5 Year	470
1	0.50%	>1.0 Year | <= 1.5 Year	475
1	0.50%	>1.0 Year | <= 1.5 Year	480
1	0.50%	>1.0 Year | <= 1.5 Year	485
1	0.50%	>1.0 Year | <= 1.5 Year	490
1	0.50%	>1.0 Year | <= 1.5 Year	495
1	0.50%	>1.0 Year | <= 1.5 Year	500
1	0.50%	>1.0 Year | <= 1.5 Year	505
1	0.50%	>1.0 Year | <= 1.5 Year	510
1	0.50%	>1.0 Year | <= 1.5 Year	515
1	0.50%	>1.0 Year | <= 1.5 Year	520
1	0.50%	>1.0 Year | <= 1.5 Year	525
1	0.50%	>1.0 Year | <= 1.5 Year	530
1	0.50%	>1.0 Year | <= 1.5 Year	535
1	0.50%	>1.0 Year | <= 1.5 Year	540
1	0.50%	>1.0 Year | <= 1.5 Year	545
1	0.50%	>1.0 Year | <= 1.5 Year	550

[Sebastian_Chaieb2 · Accepted solution]

Hi @PB41091 

Not sure if I understand this correctly but lets try to check my solution: 

First Container is generating 50 records where from the basic value 250 (or290) next 49 values are incremented by 5

Second container do the same but for 10 values and decremental.

Then I unionid and sort them

 

[PB41091]

Thank You Sebastian_Chaieb2

Your solution worked for me