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
Use the CSV output type rather than the flat file format.
You can specify the delimeter (and include headers for free)
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|WAGES10217|2016-07-26|200|REG|39.64|596.1610088|2016-08-05|802|REG|62.23|1453.0010621|2016-07-30|120|REG|71.25|959.5210432|2016-08-15|160|REG|74.99|1230.1010405|2016-07-28|320|REG|91.11|1511.7310291|2016-08-06|290|REG|42.01|541.3510452|2016-08-03|220|REG|71.84|1092.90
Thanks!
