Skip to Content
avatar image
Former Member

How to export data from HANA table along with Column Header/Column Name

Hello All,

I am trying to export data from HANA Table to excel CSV format. Data is exported but column headers aren't coming.

Note : Exported data manually using mouse clicks and also using export SQL function.

Please let me know how do I handle this. When I export data it should be exported along with column header data.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 08, 2017 at 10:46 AM

    Hello Sami,

    please select the table right click on it & select open content,

    select one of the record & click on insert query, it will pop up insert statement, close it.

    again go back to content page & click on one of the record & click export result, save it

    and open in a note pad.

    Thanks & Regards,

    Phani Kishore Akella

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Phani,

      Thanks for your reply.

      Actually I had performed this activity prior to my post. This is a manually activity after seeing the content of a table.

      But my requirement is to get the results with column header. When you do a direct export on table or by SQL export function.

      Please suggest me if we can achieve this. Or does this differ from support pack as Currently I am using SP9.

      Thanks,

      Sami