Merge tables SQLite

This software merges n tables in CSV (separator TAB) and rearranges them according to the first column values (see also Concatenate n tables). This software build a SQLite script and run SQLite. It has been tested on Linux only. The default limits for SQLite are : 2000 columns (see Replace first delimiter in tables) and 1.8e19 rows. No gaps in the merged table, only similar rows are merged.

Manual :

Tables headers are mandatory. The name of the first column must be the same in all tables.

1- install Julia 1.3 free programming language

2- install SQLite

3- unzip the software

4- copy your n tables in csv (TAB delimitated only) files in the “data” directory

5- execute the software by the command :

Usage :

julia merge_n_table_sqlite_09.jl <table separator>

Examples :

julia merge_n_table_sqlite_09.jl : TAB separator by default

julia merge_n_table_sqlite_09.jl tab : TAB separator

julia merge_n_table_sqlite_09.jl ";" : <;> separator

6- processed file is in the “result” directory.