Structuring of Excel output-file in GAMS

Problems with syntax of GAMS
Jarenka
User
User
Posts: 64
Joined: 5 years ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka »

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: 639
Joined: 7 years ago

Re: Structuring of Excel output-file in GAMS

Post by Renger »

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: Read my blog on modeling at The lazy economist
Jarenka
User
User
Posts: 64
Joined: 5 years ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka »

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: 639
Joined: 7 years ago

Re: Structuring of Excel output-file in GAMS

Post by Renger »

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: Read my blog on modeling at The lazy economist
Jarenka
User
User
Posts: 64
Joined: 5 years ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka »

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: 639
Joined: 7 years ago

Re: Structuring of Excel output-file in GAMS

Post by Renger »

Csv is easier for processing
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist
Jarenka
User
User
Posts: 64
Joined: 5 years ago

Re: Structuring of Excel output-file in GAMS

Post by Jarenka »

Thank you very much for your help!

Best
Jarenka
Post Reply