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
-------------------------------------------------------