Data360 Analyze

 View Only
  • 1.  Convert Row into field names?

    Posted 05-03-2023 10:15
    Edited by Geoff Geoff 05-03-2023 10:47

    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
    ------------------------------



  • 2.  RE: Convert Row into field names?

    Employee
    Posted 05-31-2023 06:31
      |   view attached

    Please see the attached zip file containing an example data flow. 




    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------

    Attachment(s)