Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Headings in a separate file

Highlighted
5 - Atom

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

Highlighted
9 - Comet
Highlighted
15 - Aurora

@TvdB,

 

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?

Highlighted
5 - Atom

Thanks, I found a solution using the "union" function.