Found the problem: by analyzing carefully the csv to be joined I spotted
a couple of lines at the end with decimal separated by comma; I turned
these commas into point and the problem went away.
Thank you
On 12/08/2015 01:16 PM, Riccardo (Jack) Lucchetti wrote:
On Tue, 8 Dec 2015, Alessandro Astuti wrote:
> Good morning; I'm working on a script that import data from several
> sources (mainly a sql database and a bunch of csv files) to get a
> single dataset where to do some analysis.
> I have a problem with a join that gives me an error and I can't
> figure out why.
> The join
> # Join the italian population by age classes, matching the proper age
> class in the dataset
> ? join
> /home/ale/Documenti/Univpm/IEB/Master_Thesis/popolazione/italia11.csv \
> MaschiIta --data=Maschi --filter="Eta<999" --ikey=Eta
> Data appended OK
>
> goes smooth as the output says; while the join
> ? join /home/ale/altit.csv Altit --ikey=CodiceComune
> Data error
>
> Error executing script: halting
>> join /home/ale/altit.csv Altit --ikey=CodiceComune
>
> gives me that error.
> The joins are supposed to work in the same way, that is match 1 value
> from the right hand dataset with n values in the inner dataset.
> Really, I have no clue about it. Thanks.
Try join with the --verbose option, that usually helps understand what
the problem is.
-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)
Università Politecnica delle Marche
(formerly known as Università di Ancona)
r.lucchetti(a)univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------
_______________________________________________
Gretl-users mailing list
Gretl-users(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users