I have to deal with following challenge:
The data for my problem are all in the same tables. Now I want to create hundreds of independent subproblems out of it. One subproblem is clealy defined by the column subproblem in every table. How can I make CPLEX to solve hundreds of these subproblems sequentially and independently?
I tried it with a main statement at the end of the .mod file. But it does not work because a defined variable "SubproblemNumber" is not available in the model formulation.
I tried it also by creating own tables for every subproblem during the data import process from SQL in the .dat file. But the problem is that it is not possible to define a variable in the SQL statement, only a fixed value.
I attached an executable .mod and .dat file. Has anybody an idea to solve it?