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

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

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

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

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom