Topics started by ndmile
Hello,I have a question related to writing a result to excel. I know how to write a matrix from a single parameter to excel, however I have trouble constructing a single table where all values match. If I have a parameter location(city, xy), where city is a set’s list, while xy has two columns (latitude, longitude), and I would like to combine with parameter Client(city,client), and parameter DistanceClient(city, distance), and parameter ClientDemand(client, poroductdemand), how do I save this data into one table where the rows and columns match?NOTE: each city has different number of clients: city1 has 4 clients, while, city2 has 8 clients, etc.How to obtained the following matrix in excel that looks like this: latitude longitude client distance productdemand city1city2city3….cityn I’m really appreciate your help :)Kind regards
Hi everbody,I want to generate an integer parameter that contain whole data from the table in one line, where the values for the same row are sparated by “,” and values of each rows are separated by “|”.Wish the final result looks like that:“1, 2 | 3, 4 | 5, 5 | 6, 7 | 8, 9 | 12, 0”Table:Location\XY Lan Long Place1 1 2 Place 2 3 4 Place 3 5 5 Place 4 6 7 Place 5 8 9 Place 6 12 0 The data is located in the parameter(cityID, XY). Where CityID corresponds to list of cities, and XY has two possible values “Lan” and “Long”.Thank you for your help :)Cheers,
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.