Page 3 of 3

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 06, 2019 11:36 am
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 !!!

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 06, 2019 11:50 am
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.

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 13, 2019 2:40 pm
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

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 13, 2019 3:17 pm
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

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 13, 2019 3:24 pm
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

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 13, 2019 3:47 pm
by Renger
Csv is easier for processing

Re: Structuring of Excel output-file in GAMS

Posted: Tue Aug 13, 2019 3:59 pm
by Jarenka
Thank you very much for your help!

Best
Jarenka