[Gretl-users] WG: append horizontal and vertical

Tuesday, 19 September 2017

Dear all,

I am trying to load a bunch of data into gretl, with a structure similar to the attached
files (time 1600), i.e. I have horizontal and vertical appending at the same time. I
basically use a script that opens the first file (like parameters_1.tsv) and then via a
loop appends all the other files. However, the horizontal appending works only for the
first files (belonging to *_1.tsv) and even there not completely, afterwards a single
entry is done for each file, with "missing" values. There is a common key in the
first column, so I thought the "update-overlap" option should work (after the
first record is complete (all 9 files above appended) and the first "item" of
each record is added (see script attached). It does not, however....

PS: the "--quiet" option is not present in the tool-tip of "append".

A WE is given with the script and the 18 files (first 2 records of my simulation
experiment). The operation should lead to two records, but it ends up with 11... Take a
look at the common key "ABMAT_ConfigID" to see what I mean with one glance,
after you imported the data.

Any idea what I am missing?

Best Frederik

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

[Gretl-users] WG: append horizontal and vertical