Output Headers to Notepad

[jonathangonzales]

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

[jdunkerley79 · Accepted solution]

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

[jonathangonzales]

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!

[jdunkerley79 · Accepted solution]

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

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