Originally posted by: sandeepsinghchauhan

I have a data matrix  in excel each column has name P,l,U

P             l             u

1            1            8

1            2          15

1            3          10

2            1            5

2            2            7

I want to make a model in which i want to create a new matrix (with the help of tuples) which every time start with 1..U

like-

P         l       U

1         1       1

1         1       2

.

.

.

.

1        1         8

1         2        1

.

.

.

.2         1        15

........same for P = 2 and 3 vary with 1..U

Please help

#DecisionOptimization
#OPLusingCPLEXOptimizer

Hi,

have you had a look at https://www.ibm.com/developerworks/community/forums/html/topic?id=bcaea400-c839-4f12-85bc-4750c48d68f3&ps=25 ?

regards

#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: sandeepsinghchauhan

But how can i every time call U with 1 to its corresponding value vary with P and l?

#DecisionOptimization
#OPLusingCPLEXOptimizer

Hi,

well first you read the tuple set and then you ll process the tuple set.

That is my advice

regards

#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: sandeepsinghchauhan

I did it. But its totally different from my problem. first thing i am extracting my data only through tuples but inside that data one variable 'U' whom i want to extract always in a range of 1..U 

https://www.ibm.com/developerworks/community/forums/html/topic?id=f4589b74-8494-4e5a-bf1a-b69a807439f4&ps=25

#DecisionOptimization
#OPLusingCPLEXOptimizer