Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

Headings in a separate file

TvdB
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

3 REPLIES 3
zajaccount
9 - Comet
DavidP
17 - Castor
17 - Castor

@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?

TvdB
5 - Atom

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