Re: merge multiple files based on a common column and each having 2k-3k columns

What code have you already written? It is much easier for us to help yoyu if we know where you are having problems.

For inspiration, maybe join - join two files according to a common key already does what you need?

Comment on Re: merge multiple files based on a common column and each having 2k-3k columns

Replies are listed 'Best First'.
Re^2: merge multiple files based on a common column and each having 2k-3k columns by nbdas (Initiate) on Sep 06, 2018 at 09:59 UTC
I have run join command of linux as join -j 1 file-1.txt file-2.txt \| join -j 1 file-3.txt - \| join -j 1 file-4.txt - > merge-output.txt but the output file doesnot open in excel in right way as generally it should have due to large number of columns may be	[reply]
Re^3: merge multiple files based on a common column and each having 2k-3k columns by poj (Abbot) on Sep 07, 2018 at 14:54 UTC
Excel has a limit of 16,384 columns. Why do you need to create such a large spreadsheet ? Are there only certain columns in each file that you are really interested in ? poj	[reply]