Please see the attached zip file containing an example data flow.
------------------------------
Adrian Williams
Precisely Software Inc.
------------------------------
Original Message:
Sent: 05-03-2023 10:14
From: Geoff Geoff
Subject: Convert Row into field names?
EDIT***** just realized I can not output the header row for excel so row one becomes the header... oops lol :)
I know I could take all the fields, list them in a create data and use that with a change metadata but that would mean I would need to monitor the data to see if any new fields appear...soo
I have a table that has a header row that has the proper field names for the XLS file.so I do a select * from table where header=1 or blah blah..
so row one has the field names that I need to use for the excel output... is this possible? either converting the field names to the row 1 value OR can the excel output use that row for the names?
Thanks!! example of a few fields.. there are a LOT of fields lol
------------------------------
Geoff Geoff
Windstream Communications
Little Rock AR
------------------------------