Forum Discussion
Smunozgonzalez
3 years agoNew Member
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 e...
mussaenda
Community Champion
3 years agoHi Smunozgonzalez ,
edhans is right.
You need to segregate the files according to its structure. Otherwise you data will be a mess.
- Smunozgonzalez3 years agoNew Member
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.