Hi. I have 78 pipe delimited text files with no headings (text file contents are the same), and an excel spreadsheet that contains said headings. What is the best way to import all 78 files and apply the headings? Thanks
Could you provide a bit more information? Do all 78 files have the same headings, different headings? How are the headings represented in the xlsx file? What do you want as an output? 78 text files with headings? Do you have an example of 1 with a heading file?
Thanks, I found a solution using the "union" function.