Add Filter Node to Header Row of Output File

[jasonlangley]

Hello, easiest question of the day I suspect, but currently self learning Alteryx. I have a CSV output files, with row 1 as headers. I want the output file row 1 to have the drop down filter nodes within it. Where/how do I do this? Thanks.

[danilang · Accepted solution]

Hi @jasonlangley 

CSV files are straight text files and can't have drop downs or the like.  Open your .csv file in notepad and you'll see this.  Excel sets itself up as the default application for CSV files, so that's why you can add filters, etc to the column headers once the file is open is excel.

Dan  

[jasonlangley]

Thanks Dan. Was just in notepad and observed the same. Alteryx output file is therefore fine; it's the App I am feeding the output file into that is the issue - I suspected anyway as it was inconsistently recognising (or not) the header row. Thanks again, appreciate you taking the time to respond.