I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file for feature ID, one for timestamp, one for the WKT coordinates, and one for the feature's length. I want to create a table joining four of them like
feature_ID | timestamp | WKT | length
I also have to combine 5 files into one to complete the data for some column since the amount of data is too large (e.g. the first file contains 1-100000 data points, the 2nd one is from 100001 to 200000 etc.) Can I do this simply by importing these files to the table in the correct order?