Structuring of Excel output-file in GAMS

Problems with syntax of GAMS
Jarenka
User
User
Posts: 50
Joined: 1 year ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka » 1 month ago

I have found "Data Query" in Excel 2016, see attachment (it did not succeed).
It stopped at around 10,000,000 rows.

I will try with Access, and others.

Thank YOU FOR YOUR HELP !!!
Attachments
code.JPG

User avatar
Renger
Posts: 384
Joined: 3 years ago

Re: Structuring of Excel output-file in GAMS

Post by Renger » 1 month ago

You shouldn't import all the rows. If you have all the rows, you probably want to summarize them. You should do that using a query and then import the data in an excel table.
____________________________________
Enjoy modeling even more: The lazy economist

Jarenka
User
User
Posts: 50
Joined: 1 year ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka » 1 month ago

Hi,

I succeeded with Access database, finally. Over 15 mln. rows.
I have no experience in Access. Is it possible to do summations or PivotTable-kind of analysis?

Do you know also, whether there is a possibility to export directly to a txt-file from gdx-file or a csv-file?

Best
Jarenka
Attachments
Capture.JPG

User avatar
Renger
Posts: 384
Joined: 3 years ago

Re: Structuring of Excel output-file in GAMS

Post by Renger » 1 month ago

Hi Jarenka

You can use gdxdump to produce a csv file.
Access allows you to aggregate/summarize your data, find maxima, minima etc.

Cheers
Renger
____________________________________
Enjoy modeling even more: The lazy economist

Jarenka
User
User
Posts: 50
Joined: 1 year ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka » 1 month ago

Yes, I have already used gdxdump for csv-files and then open them in Access database.

So you mean that txt-files are not a good option as an export file for GAMS, right?

Best,
Jarenka

User avatar
Renger
Posts: 384
Joined: 3 years ago

Re: Structuring of Excel output-file in GAMS

Post by Renger » 1 month ago

Csv is easier for processing
____________________________________
Enjoy modeling even more: The lazy economist

Jarenka
User
User
Posts: 50
Joined: 1 year ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka » 1 month ago

Thank you very much for your help!

Best
Jarenka

Post Reply