Forum Discussion
HELP FILES NO HEADERS
Hello!
Can you please help me?
I have multiple text files that I need to consolidate, but these files do not have headers (titles) and also do not have the same structure (unordered columns). For example one file has 2 columns, column 1 is DNI and column 2 is country. Another file has 3 Columns. Column 1 contains the city, column 2 contains the DNI and column 3 the number of children.
As I mentioned at the beginning the files do not have headers, the first row contains data. Is there any way to consolidate?
Greetings.
3 Replies
- edhans
Community Champion
You will have to identify a pattern, or manually create the transformation for each of the files. There is no simple way to consolidate files that are randomly populated or organized.
- mussaenda
Hi Smunozgonzalez ,
edhans is right.
You need to segregate the files according to its structure. Otherwise you data will be a mess.
Hello,
I have 12 files approximately, even if they are not many, these have too many rows of data.
For example, 3 files contain the same structure, 2 others a different structure (more columns than other files, and disordered).
Is there any function that allows for example to indicate that if any of the columns of the table (text file) contains 9 characters indicate that it is the DNI. There is a pattern that is repeated in some files by the length/width of the text of each column.
