topic Add Filter Node to Header Row of Output File in Alteryx Designer Desktop Discussions

Add Filter Node to Header Row of Output File

jasonlangley — Fri, 01 Mar 2024 10:30:08 GMT

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.

Re: Add Filter Node to Header Row of Output File

danilang — Fri, 01 Mar 2024 12:53:52 GMT

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

Re: Add Filter Node to Header Row of Output File

jasonlangley — Fri, 01 Mar 2024 12:59:15 GMT

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.