community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Output Headers to Notepad

Highlighted

I am outputting data to a Notepad file and I was wondering if there is a way to add the headers to the export.

A little bit hacky but a simple solution is to use a multi field formula to spit the column names in as a first row.

 

Sample attached

 

That worked perfectly.

Do you happen to know how to deliminate the data by a pipe ‘|’ ? 

Example below.

 

BU|DAY_IDNT|TEAM_NUMBER|PAYCODE|HOURS|WAGES
10217|2016-07-26|200|REG|39.64|596.16
10088|2016-08-05|802|REG|62.23|1453.00
10621|2016-07-30|120|REG|71.25|959.52
10432|2016-08-15|160|REG|74.99|1230.10
10405|2016-07-28|320|REG|91.11|1511.73
10291|2016-08-06|290|REG|42.01|541.35
10452|2016-08-03|220|REG|71.84|1092.90

 

Thanks!

Use the CSV output type rather than the flat file format.

 

You can specify the delimeter (and include headers for free)

Labels